We provide IT Staff Augmentation Services!

Sr. Etl Informatica Developer / Project Consultant Resume

2.00/5 (Submit Your Rating)

Mounds View, Mn

SUMMARY

  • Experienced in Informatica PowerCenter 10.1, 9.6.1, 8.6.1, DVO, Informatica Developer, Oracle 11g/10g/9i/8 PL/SQL, SQL, Unix Bash/Korn Shell Scripting, Data modeling
  • Most recent 8+ years hands - on ETL (Data Warehousing/ Data Conversion) development
  • Certified Informatica Developer
  • More than 10 years IT experience including onsite experience in USA (10 yrs), Singapore (2 yrs) Ireland (1 yrs)
  • Worked in functional areas viz. Manufacturing, Healthcare, Brokerage, Finance/Banking, Investment Banking, Retail Internet Banking, Retail, PL/SQL to Informatica migration
  • Master of Science in Software Engineering from Fairfield University, CT, USA

TECHNICAL SKILLS

  • Creating Tech Specs, designing and developing ETL components, applying ETL best practices, guiding ETL developers, providing production support of DB applications
  • Informatica PowerCenter, Grids & pipeline partitioning, DVO, Data Warehouse ETL, Data Conversion & Informatica administration
  • Oracle 11g/10g/9i/8 PL/SQL, SQL, DB2, Dimensional Modeling
  • Unix Bash/Korn Shell, Linux, Autosys, IBM Maestro, SQL Loader, SAP R3 LSMW
  • Toad, SQL*Plus, Putty, Xterm, DB Artisan, UML, MS Visio, PVCS, AccuRev, Harvest Version Control, AnthillPro build and deploy

PROFESSIONAL EXPERIENCE

Confidential, Mounds View, MN.

Environment: Informatica PowerCenter 10.1, Oracle 11g, SQL, PLSQL, Unix, Toad, SAP R3 LSMW

Sr. ETL Informatica Developer / Project Consultant

Responsibilities:

  • System analysis, technical design and produce technical specification documents utilizing Visio
  • Design and implement complex data transformations logic, de-normalization, aggregation logic, incremental data load and transformations based on data flow listed in XREF
  • Develop complex ETL components to incrementally fetch and load data based on date range or list to partitioned target tables
  • Develop hierarchical data transformations
  • Read data from various sources namely relational databases, flat files, XML, etc
  • Merge data from multiple sources on row level and column level based on transformation rules
  • Develop transformations to assign Unique Keys for data sets merged from two sources
  • Identify and implement best practices in ETL
  • Propose, Design and Implement solution for complex data transformations based on business rules
  • Performance tuning and optimization of Informatica workflows using optimization techniques, grids & session partitioning and tuning PL/SQL packages, Materialized views, using Explain plan, SQL trace and tkprof, SQL hints
  • Develop validation and recon scripts, recon reports utilizing SQLs
  • Guide and mentor ETL developers
  • Load data into SAP R3 using LSMW tool

Confidential, LA

Environment: Informatica PowerCenter 9.5.1, 9.1.0, 8.6.1, Data Validation Option (DVO),Oracle 11g/10g, Unix, SQL, PL/SQL, Facets

Informatica Developer / Specialist / Project Consultant

Responsibilities:

  • Design / create technical design and produce ETL specs
  • Design and implement historical data transformations and SCD type 2 utilizing Informatica Dynamic Lookup
  • Extract data from Facets source
  • Design and develop ETL for Member and Group subject area
  • Developing complex ETL codes for overlapping windows in source records
  • Design and implement hierarchical dimensions, fact table, summary tables and data structures
  • Dimensional modeling
  • Moving data from teh source systems into teh data warehouse - Facets & CSV files into teh data warehouse
  • Moving data within teh data warehouse
  • Extracting data out of teh data warehouse
  • Interacting with business users to gather requirements
  • Assisting with defining ETL standards & processes
  • Ensuring timely delivery of required ETL tasks
  • Conforming to current standards and processes
  • Performance tuning ETL utilizing pushdown optimization etc

Confidential, Minneapolis, MN.

Environment: Informatica PowerCenter 9.1, Oracle 10g, DB2, Unix, SQL, PL/SQL, Autosys, MS Visio, Harvest, AnthillPro

Sr. ETL S/W Software Developer

Responsibilities:

  • Create technical design and produce ETL specs
  • Design & develop ETL components for portfolio statistical calculations
  • Design, develop and load Accumulated Snapshot and Periodic snapshot Fact tables
  • Process mutual fund file from Morningstar, replicated data from Reuters
  • Brokerage Data warehousing & Operational Data Source ETL processing
  • Design ETL for high volume data load and extended data retention
  • Design and develop ETL comp to read/process Active Directory (LDAP) & XML sources
  • Identify and implement best practices in ETL
  • Propose, Design and Implement solutions for data transformations using Informatica
  • Design ETL enhancements to highly complex logic
  • Participate in Dimensional Modeling
  • Analyze and optimize ETL job performance
  • Build, deploy code and participate in release planning
  • Code Review
  • Maintain and post deployment support
  • Agile methodology

Confidential

Environment: menformatica PowerCenter 9.1 / 8.6.1, Oracle 10g, Unix, SQL, Toad

Role: IT Consultant / Informatica SME & Administration

Responsibilities:

  • Informatica System Administration
  • Installing & configuring domains, nodes & grids
  • Installing & configuring Repository services & Integration services
  • Engaging Informatica technical support in troubleshooting system issues
  • ETL batch performance tuning
  • Create technical design and produce ETL specs
  • Identify and implement best practices in ETL
  • Propose, Design and Implement solutions for data transformations using Informatica

Confidential, Mounds View, MN

Environment: Informatica PowerCenter 8.6.1, Oracle 10g, SQL, Unix, Toad, SAP R3 LSMW

IT Consultant / Sr. Developer - ETL / Informatica

Responsibilities:

  • System analysis, technical design and produce technical specification documents
  • Develop complex ETL components to incrementally fetch data based on date range or list
  • Implement solution for complex data transformations
  • Load data into SAP R3 using LSMW tool

Confidential, Canton, MA.

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g PL/SQL, SQL, Materialized views, Unix Bash shell scripting, SQL*Loader, XML, Toad, Erwin, Perl, Appworx, OBIEE

Sr. ETL Developer / Technical Manager

Responsibilities:

  • Requirements gather, analysis, design, build, maintain and support ETL components using Informatica Power Center 8.6.1, Oracle PL/SQL Packages, Unix shell script, SQL*Loader
  • Participate in complete project life cycle
  • Involve in system analysis, functional design and produce technical specification document
  • Design and implement historical data transformations and SCD type 2 in Informatica and PL/SQL
  • Design and implement hierarchical dimensions and data structures in Informatica and PL/SQL
  • Migrate PL/SQL code to Informatica
  • Design and implement complex data transformations logic, de-normalization, aggregation logic and incremental data load
  • Performance tuning and optimization of Informatica workflows using optimization techniques, grids & session partitioning and tuning PL/SQL packages, Materialized views, using Explain plan, tkprof, dbms mview.explain mview, explain rewrite dbms advisor.tune mview, SQL hints
  • Leverage partitioned tables & parallelism, bulk collect to improve performance
  • Define Indexing strategy
  • Design data model for Staging, Enterprise Data Warehouse (EDW) and Business Analytical Layer (BAL) using MS Visio / Erwin and produce ERD (3NF for EDW and dimensional model for BAL)
  • Implement job chaining and dependencies using Appworx scheduling tool
  • Analyze, troubleshoot and fix breaks in reports and report feeds, provide technical solution to production issues, perform sole responsibility of system delivery and signoff
  • Perform lead role in generating ETL process models and technical implementation guidelines

Confidential, Canton, MA

Environment: Informatica PowerCenter 8.6.1, Oracle 10g/11g PL/SQL, SQL, Materialized views, Unix Bash shell scripting, SQL*Loader, Toad, Erwin, Perl, Appworx

ETL Consultant Developer - Data warehouse ETL / Informatica

Responsibilities:

  • Gather requirements, analyze, design, build, maintain and support ETL components using Informatica Power Center 8.6.1, Oracle PL/SQL Packages, Unix shell script, SQL*Loader
  • Participate in complete project life cycle and produce technical specification document
  • Design and implement complex data transformation logic, de-normalization, aggregation logic, incremental data load
  • Optimize Informatica session performance using grid computing and session partitioning
  • Work on data modeling and produce ERD (3NF for EDW and dimensional model for BAL)

Confidential, Marlborough, MA.

Oracle PL/SQL ETL consultant-developer

Responsibilities:

  • Data mart ETL process design and development, enhancements and maintenance of ETL components using Oracle technology
  • Develop new modules and improve ETL components by creating Oracle objects (PL/SQL packages, partition tables, materialized views), Unix shell scripts, Maestro jobs, Perl scripts
  • Implement de-normalization and complex data transformations logic
  • Implement historic data transformations and aggregation logic
  • Involve in system analysis, technical design and produce technical specification document
  • Design and implement ETL data transformation logic
  • Performance tuning and improvement of teh data loading batch jobs in PL/SQL package
  • Identify and utilize teh most appropriate Oracle technology, Oracle PL/SQL and SQL techniques in teh software development process
  • Work with teh GRM Reporting Team to enhance teh overall quality of teh Data mart repository by participating in teh design of teh existing & new modules, and to improve teh overall software engineering practice
  • Apply my expertise in object oriented analysis, data modeling, and UML to design teh software system using MS Visio/Erwin
  • Analyze and troubleshoot breaks in reports and report feeds and provide technical solution to production issues

We'd love your feedback!