Vacancy expired!
ETL/ Informatica Developer (Strong on SQL) Alpharetta, GA (Remote till pandemic only) Contract position Need minimum 10 years of Experience Skills Required
- Hands-on experience working with Informatica power centre.
- Perform development role in Informatica, Database and Unix
- Should have good knowledge on performance tuning in Informatica
- Experience in shall scripting
- Worked with large data sets and proficient using of Analytical functions
- Experienced in running an end to end ETL project interacting with users globally
- Strong knowledge of working with relational databases like DB2, Oracle, Sql server.
- Knowledge of file transmission using any messaging framework
- Engage with Client to participate in requirement gathering, Status update on work, UAT and be the key partner in the overall engagement
- Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications
- Crafts ETL Mappings, Mapplets, Workflows, Worklets using Informatica PowerCenter
- Write complex SQL queries with performance tuning and optimization
- Identifies data sources and works with source system team and data analyst to define data extraction methodologies.
- Good knowledge in writing complex queries in DB2/Oracle PL/SQL.
- Maintain batch processing jobs and respond to critical production issues.
- Strong experience with Data Analysis, Data Profiling, Root Cause Analysis.
Vacancy expired!