Sr. Etl Informatica Developer / Project Consultant Resume
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