As an ETL developer, a person will be responsible for the implementation of processes (scripts writing or mappings design) to extract, transform, clean, and move data and metadata so they can be loaded into a data warehouse, data mart, or operational data store.
7+ years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Data Modelling, Application Development, Implementations and Testing of Applications in Data warehouse and data integration environments.
Extensive Data Warehouse experience using Informatica Power Center 10x/9x (Source Analyzer, Repository Manager, Server Manager, Mapping Designer, Mapplet Designer, Transformations Designer, Warehouse Designer) as ETL tool on Oracle, SQL Server and other databases and flat files.
Comprehensive Knowledge of Data Modeling Concepts including Dimensional Data Modeling, Star/ Snowflake Schema Modeling.
Strong knowledge and experience in interacting with various databases with SQL/PL SQL programming.
Solid experience in writing SQL queries, PL/SQL, Stored Procedures, Triggers, and optimization.
Should have experience in gathering requirements from business users.
Experience in integration of various data sources like Oracle, SQL Server, Flat Files, and XML into target tables.
Hands on experience in all aspects of Software Development Life Cycle (SDLC).
Experienced in overall data warehouse, database and ETL tuning for better performance
Experience of preparing FSD/TSD (Functional/Technical Specification Document) documents from BRD (Business Requirement Document) / Customer Requirements.
Experienced in Performing Unit testing, regression testing, sanity testing, and system integration testing for Dry runs.
Extensive experience in Performance Tuning, identifying and resolving performance bottlenecks of targets, sources, mappings, coordinate with DBAs for ETL tuning.
Well Experienced in doing Error Handling and Troubleshooting using various log files.
Proficient in creating mappings/Mapplets using Informatica Lookup, Aggregator, Joiner, Expression, Filter, update strategy, Source Qualifier, Union, and Normalizer Transformations
Strong Knowledge of any scheduling tool (Control_M to schedule ETL jobs)