Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Hyderabad Jobs |
Banglore Jobs |
Chennai Jobs |
Delhi Jobs |
Ahmedabad Jobs |
Mumbai Jobs |
Pune Jobs |
Vijayawada Jobs |
Gurgaon Jobs |
Noida Jobs |
Oil & Gas Jobs |
Banking Jobs |
Construction Jobs |
Top Management Jobs |
IT - Software Jobs |
Medical Healthcare Jobs |
Purchase / Logistics Jobs |
Sales |
Ajax Jobs |
Designing Jobs |
ASP .NET Jobs |
Java Jobs |
MySQL Jobs |
Sap hr Jobs |
Software Testing Jobs |
Html Jobs |
Job Location | Hyderabad |
Education | Not Mentioned |
Salary | Not Disclosed |
Industry | IT - Software |
Functional Area | General / Other Software |
EmploymentType | Full-time |
ETL Informatica Developers:Location: Hyderabad , IN.Technical Skills6+ years of experience in Information Technology with emphasis on Data Warehouse / Data Mart development using developing strategies for extraction , transformation , and loading (ETL) inInformaticaPower Center from various database sources. Strong work experience in Data Mart life cycle development , performed ETL procedure to load data from different sources like SQL Server , Oracle , Teradata , DB2 , COBOL files & XML Files and flat files into data marts and data warehouse using Power Center Repository Manager , Designer , Server Manager , Workflow Manager , and Workflow Monitor. Involved in understanding of Business Processes , grain identification , identification of dimensions and measures for OLAP applications. Highly motivated and goal - oriented individual with a strong background in SDLC Project Management and Resource Planning using AGILE methodologies Strong knowledge of Entity - Relationship concept , Facts and Dimensions tables and developing database Schemas like Star schema and Snowflake schema used in relational , dimensional and multidimensional data modeling. Comprehensive experience of working with Type1 , Type2 methodologies for Slowly Changing Dimensions (SCD) management. Proficient in the Integration of various data sources with multiple relational databases like Oracle11g / Oracle10g / 9i , MS SQL Server , DB2 , Teradata , Flat Files into the staging area , ODS , Data Warehouse and Data Mart Extensive experience in developing Stored Procedures , Functions and Triggers , Complex SQL queries using SQL Server TSQL and Oracle PL / SQL. Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions. Good working knowledge of variousInformaticadesigner transformations like Source Qualifier , Dynamic and Static Lookups , connected and Unconnected lookups , Expression , Filter , Router , Joiner , Normalizer and Update Strategy transformation. Worked on Performance Tuning , identifying and resolving performance bottlenecks in various levels like sources , targets , mappings and sessions.,
Keyskills :
informatica etl sql unix mapping mssqlserver sourcesystemanalysis mssql oraclepl sqlserver oracle10g oracle11g lifecycle datamarts flatfiles sqlqueries starschema resourceplanning toredpro