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
- 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
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
Informatica Developer / Specialist / Project Consultant. Design, develop
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 the source systems into the data warehouse - Facets & CSV files into the data warehouse
- Moving data within the data warehouse
- Extracting data out of the 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.
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, VA
IT Consultant / Informatica SME
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
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, MA
Sr. ETL Developer / Technical Manager - Data warehouse ETL / Informatica
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
ETL Consultant Developer - Data warehouse ETL / Informatica / Oracle 10g PL/SQL based in
Confidential, MA, USA
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)
Environment: Unix Cluster, Oracle 10g/9i PL/SQL, SQL, Perl, Unix Korn shell scripting, IBM Tivoli Maestro Scheduling, PL/SQL Developer, AccuRev
Oracle PL/SQL ETL consultant
Confidential, MA, USA
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 the data loading batch jobs in PL/SQL package
- Identify and utilize the most appropriate Oracle technology, Oracle PL/SQL and SQL techniques in the software development process
- Work with the GRM Reporting Team to enhance the overall quality of the Data mart repository by participating in the design of the existing & new modules, and to improve the overall software engineering practice
- Apply my expertise in object oriented analysis, data modeling, and UML to design the software system using MS Visio/Erwin
- Analyze and troubleshoot breaks in reports and report feeds and provide technical solution to production issues
- Provide technical solution to production issues in FOREX trading applications namely Middle Office Repository, Real Time Analytics, reports
- Analyze and fix breaks in trade feeds & report feeds, feeds to various upstream and down stream systems, data issues with FOREX rates & static data for various clients