ETL Informatica Lead - Business Intelligence

SUMMARY:

Versatile, highly execution oriented, fast learner, high performing individual working in the role of Technical lead to build Enterprise Data Hub, using a blend of great leading technologies like Informatica, Greenplum, Spotfire and Oracle. At Core technical specialist, knowing technologies spanning from programming to data visualization. Apart from being a developer, performed various key responsibilities as integration testing, end-to-end delivery, requirement gathering and analysis. In order to summarize, one member team who can take complete ownership of end-to-end defect free delivery.

TECHNOLOGY PROFILE

Informatica, Spotfire, Oracle, UNIX Shell Scripting, Business Objects, Cognos, Microsoft SQL Server, Greenplum, Perl

TECHNICAL SKILLS

Technology Business Intelligence, Data Warehousing

Area of Expertise (6 years) PowerCenter Informatica 9.6.1, Unix Shell scripting, Oracle

Scripting UNIX Shell Scripting, Perl Scripting

Training (6 months) Power Center Informatica, Business Objects, Cognos, UNIX

Database Oracle, Greenplum

Operating Systems Windows & Linux

PROFESSIONAL EXPERIENCE

6 years Experienced - DW BI ETL Informatica Lead(H1-B Visa Holder)

Result oriented and competent professional offering over 6 years of rich exposure in ETL and Data warehousing, having the ability to work on multiple projects simultaneously actively contributing in functional and technical aspects.

Having complete ownership of end-to-end delivery and SDLC cycle enabled building a strong relationship with client, stakeholders, vendors and development teams.

Working on multiple projects simultaneously taught me time- management and leadership skills. Also being self-driven, I learnt new technologies myself and successfully deployed projects like Perl and Greenplum.

Recently working on projects re-writing and designing re-existing Oracle PL/SQL code into Greenplum.

ETL performance tuning, optimization and Value Innovation is my strong aspect.

Experienced in data analysis, requirement analysis and worked on providing data for data mining projects.

Strong communication skills and ownership abilities.

Strong experience in Informatica ETL development (Design, Develop and modify Informatica mappings and workflows) and ETL performance tuning and optimization.

Sound exposure and working knowledge of Requirement Analysis, Planning, ETL Designing, Scripts, Execution and other Quality Assurance Processes.

Excellent time management skills with proven ability to work accurately and quickly prioritize, coordinate and consolidate tasks, whilst simultaneously managing the diverse range of tasks from multiple sources.

Detail-oriented with strong tactical skills required for large strategic business picture and making optimal long-term decisions. For example, one of my project has heavy impact on downstream applications.

EXPERIENCE

January 2011 – Present Capgemini (previously known as iGATE Corporation) as Tech Lead

EDUCATION

2006 - 2010 B. Tech. in Electronics & Communication Engineering from Punjab Technical University, Chandigarh (Punjab, India)

WORK EXPERIENCE

Role: ETL Informatica Lead

Client: Genworth Financial

Major Responsibilities:

Handling multiple projects simultaneously helped me learn time-management skills and leadership skills.

Developed many fully automated processes with a perfect blend of ETL Informatica, UNIX, Oracle PL/SQL, Greenplum, Perl and Spotfire which in turn saved huge amount of time and efforts of time-critical resources.

Value Innovation: By using one complex ETL mapping in loop, a complete SAS code of 5000+ lines was decommissioned. Also, reducing the run-time from 20 hours to 5 hours.

Design the project for best possible dynamic solution to handle frequently changing requirements.

Prepare the high level and detailed design document for project.

Develop Informatica code (Simple and complex) based on requirements.

Optimization and Automation of ETL processes.

Detailed unit/integration testing.

Different types of projects:

Agile methodology Project

Zero touch fully automated process eradicating manual efforts which is helpful in critical monthly, quarterly and yearly runs.

Dynamic parameter files driven by oracle tables using shell scripting.

Estimate project plan considering downstream applications and other modules.

Develop and design Informatica mappings and workflows based on requirements.

Optimization and Automation of ETL processes.

Single Resource Development Project: Reconciliation of rates from Admin system to Valuation system using ETL (Informatica), Oracle and Perl. Perl was a new skillset that I learnt myself for this project.

Enhancement Project: Re-write and re-design existing SAS code in ETL Informatica. Reducing the turnaround time to 5 hours from 20 hours. Also, complete automation significantly reduced manual efforts.

Enhancement and Production Support:

Production support of 50+ applications involving monitoring and resolution of production incidents within SLA.

Responsible for very critical Month end/Quarter end runs.

Resolved incidents with quick turnaround time like file missing, ftp issues, unique constraints, server/network issues, database size issue, and invalid file format issue.

Development Project: Designing and developing Enterprise Data Hub which is catering a clean and single version of data to almost 20 sensitive critical applications. Hence, resolving syncing and time-lapse issues for all downstream applications.

(ADITI GARG)

Contact this candidate