• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 21st Dec 2020

The Informatica ETL Developer would design and develop ETL processes for enterprise integration applications, as well as maintain and support production jobs.
Assists with wide scope of Analytics, Business Intelligence and Data warehouse initiatives designed for enterprise data needs, works collaboratively with data analysts and
other teams.
Responsible for data quality, performance ,logical and physical data flow models for ETL applications

 Day to Day Responsibilities:

• Design, build and test ETL solutions using Informatica PowerCenter/Power Exchange 10.x and prepare corresponding technical specifications
• Provide subject matter expertise on Informatica suite of products including Data Quality, Data transformation, B2B Data exchange, Data services, PowerCenter, Power Exchange with CDC and others
• Implement best practices and tune code for optimization maintaining high levels of quality. Ensure versioning of ETL repository and support code as necessary
• Work with Data Analysts and DBA's to plan and implement integration solutions supporting data warehouse and data reporting needs
• Create registration and extraction groups for CDC on ISeries AS400 files, Configure real-time connections for pulling data from AS400 journals
• Perform all Informatica administration functions such as user access accounts, roles, privileges, and LDAP configuration. Configure domain and application services
• Translate the functional requirements so as ttohe specified technical requirements. Engage in training team on applications of data cleansing, data quality, data matching, etc.

Performs other related duties as assigned.

Hands on experience with Informatica PC, Informatica PX with CDC for 5-7 years; Knowledge of data warehouse technologies (Netezza, Snowflake, etc.);
Experience with windows batch scripting;
Exposure to analytic tools (Cognos, Power BI, etc.); Knowledge of database administration, SQL query optimization, stored procedures, and related database tools;
Experience on Windows Servers and SQL Servers