Sr ETL Developer - Informatica PowerCenter

Must Have Skills At least 5+ years of experience in developing ETL solutions using Informatica PowerCenter. Experienced in designing and developing Informatica PowerCenter ETLs for DB2/MS SQL Server/Oracle Database loads Hands on experience working in data migration projects Experienced of working in MS SQL/ Oracle Server database. Hands on development and maintenance experience in shell scripting Work with business team to understand and design ETL solution for requirements. Hands on experience in performance tuning Informatica PowerCenter Mappings, capacity planning and developing High Volume Data Loads. Strong experience in developing efficient SQLs for querying RDBMS Systems. Hands on experience with version control systems like GIT. Experienced working in an Agile environment. Strong communication skills High preference for candidates with below additional skills Strong in SQL development and shell scripting Experienced with Procedural Language development. Exposure to Banking/Mortgage domain will be plus Responsibilities Provide technical leadership and support for inbound/outbound data integration (ETL), maintenance/tuning of applications, data model changes, data profiling, data quality assessment, executing and monitoring incremental updates, and working with infrastructure and DBA teams to maintain multiple environments (development/test/production). Knowledge on Data Modelling and familiarity with Dimension and Fact tables design. Strong SQL performance tuning capabilities for relational DB. Strong UNIX and shell scripting experience is required Autosys scheduling experience. Must be detail oriented and possess strong problem-solving skills. Design, develop and test PowerCenter mappings and workflows. Develops scripts to execute and test mappings and workflows. Must be facilitating the establishment and implementation of standards, guidelines and best practices that guide the various PowerCenter and Data Warehouse projects within the organization. Able to provide data architecture solutions. Strong analytical and technical aptitude experience required. Work with migration team and push code changes to production. Coordinate and work with testing teams during integration testing phases Collaborate with source systems data stewards and technical personnel for data governance and to resolve any data quality or technical issues related to data ingestion. Must be experienced on both; Linux & Windows operating systems. Providing guidance and assistance to team members