Software Engineer Lead
ETL Developer _4 to 6 Years
Job Description
Understand & interpret upstream and downstream data flow, do data profiling, data mapping and Check Data Quality from Source to Target.
• Perform impact analysis of new systems, new interfaces & integration. Work on impact analysis to reference data (domain/dimension; data elements/properties; base members/data sets; hierarchies) to ensure compliance with Data Governance principles. Manage critical relationships with consultants and vendors, internal end users, and business leaders.
• Implement high-quality solutions by translating business requirements into integration specifications, working with ETL developers to oversee the implementation of ETL designs.
• Responsible to develop ETL architectural and design patterns, considerations, solution options, and impact.
• Design, develop, and implementation ETL solutions using Informatica tool.
• Identification and analysis of data issues impacting financial services organizations.
• Assist with the development and enforcement of integration standards using knowledge of the current data environment, regulatory issues and industry trends to identify and implement leading industry data practices.
• Ability to conduct discovery, perform root cause analysis, and make recommendations for the remediation of data quality issues.
• Facilitation and definition of reporting and analytics business requirements.
• Provide post-production batch support.
• Conduct unit test, SIT, and provide UAT support.
Functional
Skills • Banking domain experience.
Technical Skills Hands-on experience on:
• Informatica PowerCenter 9.6.1
• Oracle Data Integrator (ODI)
• SQL Query (Teradata / Hadoop) – Intermediate / Advance
• Oracle – PL/SQL, SQLLoader
• Hadoop HDFS
Ideal to have but not pre-requisite:
• Unix AIX basic command & shell scripts
• Teradata (TPT)
• ASG-ZENA (Job scheduler)
• IBM DataStage ETL Tool
• JAVA
Bangalore, KA, IN