We provide IT Staff Augmentation Services!

Sr. Informatica Developer Resume

Herndon, VA

SUMMARY

  • Around eight years of expertise in data warehousing projects including Data Integration, Data Migration and Data Enablement using Informatica as the ETL tool
  • 4+ years of expertise in leading the ETL projects through all phases of SDLC right from requirements elicitation till production support
  • Proficiency in designing and implementing Optimized, high quality and robust ETLS to meet the business requirements
  • In depth understanding of Enterprise Data Warehouse Architecture, concepts of data warehouse modeling approaches Confidential dimensional modeling and Inmon’s normalized data model and good exposure to the Data Vault modeling, a database modeling method
  • Extensive experience in working with Informatica power center along with relational databases Oracle, Teradata and heterogeneous data sources including FLAT files, Excels and XML
  • Hands on experience with Informatica Cloud and other ETL tools like Business Objects Data Services and Open Source ETL tool Pentaho
  • Exposure to Informatica Data Quality Analyst and Developer
  • Good understanding of Teradata Architecture
  • Strong in analyzing and writing complex queries using SQL in Oracle and Teradata
  • Expertise in Job scheduling tool $U(Dollar Universe) and exposure to DAC, Autosys
  • Good exposure to UNIX Shell scripts, Linux
  • Well versed with performance tuning for ETLS and SQLs in Oracle and Teradata
  • Extensive experience in implementing projects using Agile(kanban) and waterfall methodologies
  • Expertise in detail oriented documentations and converting the Business requirements into technical design documents
  • Well recognized for the high quality deliverables
  • Good at gaining functional knowledge. Worked as SME for few modules in Revenue Management
  • Strong analytical, debugging and problem solving skills to undertake challenging jobs
  • Excellent communication skills and abilities to interact with various cross functional teams including business teams to ensure the successful delivery of the projects
  • Quick adaptability to new, emerging technologies with abilities to work as a good independent player and a very good team player as well

TECHNICAL SKILLS

ETL Tools : Informatica 8.6/9.5, BODS, Pentaho, Informatica Cloud

Data Quality Tools: IDQ Analyst, Developer

RDBMS Tools : Toad, SQL Assistant, SQL Developer

RDBMS : Oracle9i/10g/11g/R12, Teradata

Version Control Tools: PVCS, SVN

Deployment Tool: Kintana, ICART

Job Scheduling Tools: Dollar Universe, DAC,Autosys

Scripting Languages: Unix Shell Script, Linux Scripting

PROFESSIONAL EXPERIENCE

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

  • Elicitation of requirements
  • Review the requirements from business
  • Source system analysis
  • High level and Detail level designing
  • Designing ETLs as per the business requirements
  • Development and review of ETLs
  • Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
  • Development of JILs in Autosys to schedule the jobs
  • Testing the ETLs and Autosys jobs
  • Build and deployment of baselines to higher environments
  • Support SIT and UAT phases
  • Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

  • Elicitation of requirements
  • Review the requirements from business
  • Source system analysis
  • High level and Detail level designing
  • Designing ETLs as per the business requirements
  • Development and review of ETLs
  • Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
  • Development of JILs in Autosys to schedule the jobs
  • Testing the ETLs and Autosys jobs
  • Build and deployment of baselines to higher environments
  • Support SIT and UAT phases
  • Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Informatica Developer

Confidential, Herndon, VA

Responsibilities:

  • Elicitation of requirements
  • Review the requirements from business
  • Source system analysis
  • High level and Detail level designing
  • Designing ETLs as per the business requirements
  • Development and review of ETLs
  • Resolve performance bottlenecks by optimizing the mappings, sessions and workflows
  • Development of JILs in Autosys to schedule the jobs
  • Testing the ETLs and Autosys jobs
  • Build and deployment of baselines to higher environments
  • Support SIT and UAT phases
  • Ensuring successful delivery of the project within the timelines defined

Environment: Informatica Power center, Informatica IDQ Analyst, IDQ Developer, Oracle, Unix, BO, EDW, Autosys, SVN, ICART

Sr. Business Intelligence Engineer

Confidential, Raleigh, NC

Responsibilities:

  • Interaction with business team for the elicitation of requirements
  • Source system Analysis
  • Impact Analysis
  • Designing ETLs as per the business requirements
  • Development of ETLs
  • Implementation of Change Data Capture (CDC) for slowly changing dimensions (SCD type1,type2 and type3) preparation of unit test case documents
  • Unit testing at various levels of the ETLs
  • Scheduling ETLs in the job scheduling tool DAC
  • Testing the Scheduled jobs
  • Code Reviews
  • Root Cause Analysis and resolution of the issues in Production
  • Resolve performance bottlenecks by optimizing the mappings, sessions and workflows

Environment: Informatica, BODS, Pentaho, Infomatica Cloud, Oracle, Linux, BO, EDW, BAW, Data Vault, DAC.

Hire Now