Job Description :
Perform full SDLC life cycle work, including analysis, design, development, enhancement, testing, maintenance and technical support for this project. • Design, implement, automate and maintain large scale enterprise data ETL processes. • Evaluate the integration a various data sources like Oracle, SQL server, VSAM and sequential files into staging area and recommends and/or implements efficiencies • Performs technical walk-through as needed to communicate design/coded solution and to seek input from team members. • Develop ETL processes using Informatica, ETL control tables, error logging, auditing, data quality, etc. • Implement data cleanup procedures, transformations, scripts, stored procedures, and execution of test plans for loading the data successfully into the targets. • Enterprise-level ETL development and ETL architecture using Informatica and understanding/ using the COBOL file structures. • Work on Oracle Database using SQL and PL/SQL. • Work on Informatica Designer Components -Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor. • Perform data analysis, data mapping, data loading, and data validation; reusability, parameterization, workflow design, etc. • Support other ETL developers; providing mentoring, technical assistance, troubleshooting and alternative development solutions. • Perform performance tuning and work end-to-end lifecycle using Enterprise wide data warehouse. Requirements and Responsibilities: • Experience with designing, developing, testing, and supporting applications. • Detailed understanding of Informatica Power center Components 9.x • Expertise working with different kinds of sources - XML, flat files, Web services etc. • Good experience in Unix Scripting • Excellent Understanding of Oracle, Microsoft Sqlserver. Need to be able to write complex queries with ease & Performance tuning. • Excellent data analysis and debugging. • Exposure IDQ preferred. • Good knowledge on Informatica Data Services (IDS), Informatica Analyst and Informatica Developer • Data mapping experience - mapping data sources to and from multiple applications. • Design, develop and implement data feeds and transformations with minimal to no guidance. • Team Player with excellent collaborative skills. Qualifications: • Bachelor''s degree in a technical field such as computer science, computer engineering or related field required • Minimum 10 years of overall IT experience • Minimum 7-8 years overall Informatica, Data Warehousing and Business Intelligence experience. • Desired experience in IDQ (Informatica Data Quality) • Expert knowledge of relational databases, flat files and non-relational database structures. • Strong knowledge of data warehousing concepts. • Understand Logical and Physical data modeling best practices and techniques • Experience in developing slowly changing dimensions, error handling and performance tuning. • Strong Data Analysis skills. • Strong Oracle SQL/PL SQL skills. • Strong Unix /Shell scripting skills • Scripting languages like Python is desired.