ETL Informatica Lead Resume Samples

Description :

1. Defined overall data ingestion architecture leveraging CDC, Data Integration, Data Quality, and Data Governance concepts.
2. Designed best practice technical and business solutions using change data capture and data integration technologies.
3. Designed, developed, modified, configured, and debugged Informatica workflows using Informatica PowerCenter and Power Exchange CDC tools
4. Led and mentored a team of ETL developers to meet committed project timelines.
5. Employed a comprehensive unit testing process to ensure the delivery meets the business requirements without compromising performance.
6. Troubleshot and resolved technical issues, debugged, tuned, and optimized code for optimal performance.
7. Handled the problem ticket analysis skills.

Experience

7-10 Years

Level

Consultant

Education

BIT

Description :

1. Worked closely in Informatica Data Transformation and Data Transformation Studio.
2. Understood Unix/Linux systems, file systems, and shell scripting.
3. Handled the design and implementation of the ETL/ELT framework for complex warehouses/marts.
4. Able to work in a team in a diverse/ multiple stakeholder environment.
5. Worked in a global delivery environment.
6. Produced application artifacts and documentation per team needs and for SDLC, Agile, DevOps governance, and audit requirements.
7. Facilitated design and code reviews independently and in partnership with others.

Experience

5-7 Years

Level

Executive

Education

BSc CS

Description :

1. Responsible for technical design, development, testing, and documentation of Data Warehouse / ETL projects.
2. Developed, implemented, and deployed ETL solutions to update data warehouses and marts.
3. Maintained quality control, documented technical specs, and unit testing to ensure the accuracy and quality of BI data.
4. Provided production support and worked with other IT team members and end users to resolve data refresh issues.
5. Performed data profiling and logical/physical data modeling to build new ETL designs and solutions.
6. Worked with users, BI, and ERP teams to get ETL solutions developed and implemented.
7. Responsible for performance tuning and enhancement of SQL and ETL processes and preparing related technical documentation.

Experience

10+ Years

Level

Management

Education

BSc CS

Description :

1. Participated in ad-hoc BI/ DW projects as required.
2. Developed and enhanced BI reports, models, and cubes and provided support as needed.
3. Worked with the offshore team to coordinate development work and operational support.
4. Kept abreast of the latest ETL technologies and planned effective use.
5. Helped to build solutions for predictive analytics and/or big data.
6. Communicated very clearly and professionally with users, peers, and all levels of management.
7. Adhered to the processes and work policies defined by management.

Experience

7-10 Years

Level

Senior

Education

BIT

Description :

1. Supported DR activities for Informatica PowerCenter.
2. Supported Informatica PowerCenter code migration/deployment activities into Production.
3. Provided simplified and standardized solutions to achieve business objectives.
4. Able to provide both innovative and improvement solutions to current and anticipated business challenges.
5. Responsible for handling database administration tasks and working with DBAs to monitor and resolve ETL (Informatica) issues.
6. Used appropriate software development methodologies prescribed by Mylan.
7. Interacted with users to gather requirements from various departments document business requirements and prepare functional specifications and mock-up designs as necessary.

Experience

5-7 Years

Level

Executive

Education

BIT

Description :

1. Delivered ETL components as specified in the design, functional, and non-functional requirements, within the established budget, time, and quality standards.
2. Performed unit testing of ETL components and documented test results.
3. Reviewed the code for ETL components and documentation of issues identified and action items.
4. Supported all testing, including Development Integration Testing, System Testing, User Acceptance Testing, End-to-End Testing, and Performance Testing.
5. Performed troubleshooting on ETL components Production Support.
6. Supported the operations of existing applications When on call, provided timely response and resolution of emergency production questions, issues, and defects.
7. Worked on periodic maintenance releases of applications, including enhancements and defects, looks for ways to enhance the design of applications for better maintainability and software reuse.

Experience

10+ Years

Level

Management

Education

BIT

Description :

1. Responsible for understanding the users use their applications and anticipating users' future needs when architecting solutions Managing Employees.
2. Reported to the Application Development Manager or Project Manager Coaches less experienced teammates.
3. Created documentation to aid in others' learning provided project supervision and ensured quality and timeliness of others' deliverables managing work.
4. Managed workload to deliver quality deliverables that meet requirements and timelines. 
5. Communicated status of assignments to manager and notifies manager of issues that impact productivity or ability to meet expectations Assists Manager in tracking progress, prioritizing work,
6. Developed time estimates and work plans and assisted less experienced team members.
7. Resolved issues or escalated to the Manager, and checked work into central repositories.

Experience

7-10 Years

Level

Senior

Education

BSc CS

Description :

1. Participated in requirements gathering sessions with stakeholders from business and IT teams. 
2. Communicated effectively with business partners to identify needs and evaluate options, translated business needs to technical requirements and developed and updated technical documentation. 
3. Researched new tools and technologies in the business intelligence arena. 
4. Designed, developed, deployed, and supported sustainable BI solutions such as dashboards, scorecards, and various other forms of data visualization. 
5. Designed, developed, deployed, and supported measure algorithms in the form of complex SQL scripts and database queries. 
6. Performed data manipulation tasks using available and most appropriate data management tools such as Informatica or SQL queries and database stored procedures. 
7. Worked independently to develop good quality deliverables and guide/mentor junior team members effectively.

Experience

7-10 Years

Level

Consultant

Education

BSc CS

Description :

1. Designed ETL processes, integration workflows, and data load processes that assist in implementing enterprise-class data integration solutions.
2. Used the IICS platform to extract, transform, and load data through the development, testing, and integration of ETL routines, using ETL tools and external programming/scripting languages as necessary.
3. Assisted in writing unit test cases along with execution.
4. Identified problems, developed ideas, and proposed solutions within differing situations requiring analytical, evaluative, or constructive thinking in daily work.
5. Developed and implemented technical best practices for data integration.
6. Developed and ensured adherence to locally defined standards for all developed components.
7. Maintained common code libraries, so objects could be shared for all environments (Dev, Test, UAT, and Production).

Experience

7-10 Years

Level

Senior

Education

BSc CS

Description :

1. Able to convert business requirements into technical specifications and decide timeline to accomplish.
2. Worked with users and team members at all levels for performance improvement and suggestions.
3. Participated in the adoption and implementation of best practices across key data elements and processes. 
4. Helped to resolve critical issues and provide technical resolution.
5. Identified the root cause analysis, prioritization, remediation planning and coordination, and execution of remediation activities for data issues
6. Participated in the development and maintenance of the technologies that automate data processes.
7. Collaborated with onsite counterparts during all phases of the project.

Experience

5-7 Years

Level

Executive

Education

BSc CS