• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 21st Dec 2020

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

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 phyical data flow models for ETL applications    

Design, build and test ETL solutions using Informatica PowerCenter/PowerExchange 10.x and prepare corresponding technical specifications

Provide subject mater expertise on Informatica suite of products including Data Quality, Data transformation, B2B Data exchange, Data services, PowerCenter,
PowerExchange 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 to meet the specified technical requirements.Engage in training team on applications of data cleansing, data quality, data matching, etc.