Job Description :
Position: Lead ETL Informatica Developer
Location: Indianapolis, IN
Interview Process: Webex
Contract Duration: 6+ Months
Visa: USC, GC, GC-EAD, H1, H4, L2, E3, TN

Job Type: Contract/Full-Time

Job Description:

12-13+ years’ experience in Primary technical skill

Primary Technical Skills:- Informatica, RDBMS, Unix/Linux

Nice To Have: Experience in Insurance domain and knowledge in Reporting tools like Business Object, Tableau, etc


Analyzing the business requirements, design, develop and implement highly efficient, highly scalable ETL processes

Required to perform daily project functions with a focus on meeting the business objectives on time in a rapidly changing work environment

Thorough understanding of DWH concepts and Data Models

Design and Develop detailed ETL specifications based on business requirements

Analyze functional specifications and assist in designing potential technical solutions

Works with source system team and data analyst to define data extraction methodologies

Advanced Oracle & SQL Server database skills including PL/SQL, packages, procedures, indexing and query tuning (5+ years)

Enhance/Re-architect existing components to satisfy new performance and scalability requirements

Regular meeting with team and stakeholders to avoid impediments

Innovative ideas on automation and Proof Of concepts to get it implemented

Proficient in ETL Informatica

Well versed in Unix shell scripting

Interact with multiple teams and translate reported problems/issues into JIRA items to implement to meet enterprise standards.

Good knowledge in writing complex queries. Experience in MS SQL is value-added

Maintain highest levels of software quality and stability through continuous improvement of the SDLC

Build and maintain design standards and best practices and ensure the team adhere these standards

Evaluates and recommends unique hardware /software configurations; defines special hardware/software requirements, capacities, capabilities, etc. to meet user needs while adhering to technical standards

Unit Integration testing activities and assist in User Acceptance Testing

Effective time management skills in order to manage multiple priorities with flexibility on time zones and timelines

Must have strong interpersonal skills and outstanding communication skill

Technical Skill


Strong hands-on experience in Informatica 10.x +.

Strong understanding of concepts and techniques for design, development, and implementation of ETL

Ability to perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)

Involved in coding, testing, implementing, debugging and documenting the complex programs.


Strong hands-on experience in any of the database like MS SQL(Preferable), DB2, Oracle, MYSQL, etc and interested to work in all databases

Should be well-versed in data analysis and query methods

Strong knowledge in data warehousing concepts

Use of Data Modeling, Database Query Optimization, and Data Access techniques and concepts


Good knowledge in Unix, Linux, Shell Scripting

Hands-on experience in using Informatica command utility like PMCMD, PMREP