We provide IT Staff Augmentation Services!

Informatica Tech Lead / Etl Architect Resume

3.00/5 (Submit Your Rating)

MichigaN

SUMMARY:

  • 10 years of experience in software development comprising of working on ETL, Datawarehouses, Databases and BI.
  • Experienced ETL Informatica Tech Lead and ETL Architect with expertise on complex Data warehouse projects in Banking(Risk Analytics), Health Insurance(Ingenix) and Automotive domains.
  • Proficient architectural skills in building data marts/data warehouses, ETL flow and Integration solutions.
  • In depth knowledge of dimensional modeling with experience in building star and snowflake schemas.
  • Worked extensively in requirements gathering, effort estimations and solution design and development for data warehouses.
  • Expertise in developing resource constrained and cost constrained technical solutions for Data warehouse ETLs based on business requirements adhering to architectural and quality standards.
  • Owned ETL solution delivery, productionizing of the solution and production daily support.
  • Excellent trouble shooting, issue analysis and impact analysis skills of production and pre - production issues in Informatica and Oracle.
  • Headed onshore offshore model development teams and led the design and development of ETL solutions.
  • In depth knowledge in Informatica and hands on experience in developing various Informatica components ( mappings, sessions, mapplets, worklets, workflows etc.) with experience in Informatica Repository and Metadata management.
  • Strong performance tuning skills in Informatica, Oracle, SQLServer.
  • Proficient in programming Unix shell scripts, Unix Cron jobs, PL/SQL stored procedures, functions, views, triggers and SQL scripts in Oracle and SQLServer.
  • Proven expertise in tuning PL/SQL code and SQL queries.
  • Experienced in scheduling Informatica jobs through schedulers like CA7 and Tivoli.
  • Experience in relational database design in Oracle and SQLSever.
  • Good knowledge of various information systems and architecture standards for building ETL solutions.
  • Knowledge of BI tools like Business Objects, Java programming.
  • Good knowledge of emerging Hadoop technologies like MapReduce, Hive.
  • Excellent team player with strong problem solving, interpersonal, oral and written communication skills, highly motivated and adaptive with ability to grasp things quickly.
  • Good knowledge of Business Intelligence and Data Warehousing.
  • Experienced in Agile Scrum methodology and Waterfall models.
  • Efficient training skills, experience in conducting training workshops on Oracle, PL/SQL and Informatica.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter

RDBMS: Oracle, SQLServer, MySQL, DB2

MPP Tools: Netezza

Tools: TOAD, PL/SQL Developer

Languages: PL/SQL, SQL

Data Modeling: ERwin, Power Designer

Data Profiling: Informatica Data Quality

Scheduling tools: CA7, Autosys, Tivoli

Version Control: Harvest, VSS

BI Tools: Business Objects

Others: Hadoop MapReduce, HIVE, JIRA, Microsoft Visio

PROFESSIONAL EXPERIENCE:

Confidential, Michigan

Informatica Tech Lead / ETL Architect

Responsibilities:

  • Primary Lead for ETL development team, support team and Confidential Finance application.
  • Designing Architecture for end to end flow of ETL solution using Informatica and Oracle for data extraction from customer interfaces to data processing, storage and routing data to SAP.
  • Requirements gathering, understanding the business needs and scope and expectations, capturing the technical scope involved, deriving the extent of ETL involvement needed in the overall project.
  • Estimating efforts (time and resources) for implementing the ETL solution, assisting with project deliverables plan.
  • Data profiling for checking data quality, composition, granularity etc.
  • Developing conceptual, logical models of data. Establishing the physical level components and assisting in setting up of data mart tables.
  • Building of dimensional model for warehouse using star schema and defining the facts and dimensions. Defining the data load frequency and criteria for the fact and dimensions developed.
  • Driving the development team for building the ETL solution, continuous monitoring of the solution for quality and on time delivery.
  • Code review of ETL code developed by development team. Identifying and assisting with problem areas, performance challenges and technical challenges in the ETL code.
  • Enforcing coding and architectural standards across the ETL solution.
  • Periodic review of code development progress to make sure on time delivery of project deliverables.
  • Developing multiple design solutions for enhancements based on time and resource constraints and presenting to business.
  • Developing Informatica reusable components like mapplets and worklets.
  • Implementing performance tuning techniques like push down optimization, multi-threading, persistent cache for Informatica jobs.
  • Setting up of dynamic cache and persistent cache for lookups in mappings in Informatica.
  • Extensively created transformations like expressions, joiner, update strategy, lookup, filter, sorter, aggregator, stored procedure, JAVA, union, router, XML, transaction control for developing mappings.
  • Data extraction and processing from varied sources like XML files, flat files, Oracle, SQLServer using Informatica jobs to load to data warehouse.
  • Writing Unix shell scripts for file transfers and parameterizing of Informatica jobs.
  • Creating cron jobs in unix for scheduling Informatica jobs and stored procedures.
  • Writing complex queries and query tuning for data profiling and analysis. Performance tuning of PL/SQL procedures and SQL queries.
  • Scheduling of ETL jobs using Tivoli.
  • Developing and executing unit and system testing plans.
  • Root cause analysis for production issues and offering multiple approaches for fixing issues so as to decide the best approach for the fix.
  • Creating ETL solution design documents and technical documents for ETL jobs.

Confidential, Cleveland, Ohio

Informatica Technical Lead / Sr. Informatica Developer

Responsibilities:

  • Gathering requirements, business needs and project scope for the project. Capturing technical requirements from the business requirements shared by Business Analysts.
  • Designing multiple feasible long term and short term ETL approaches for end to end data flow/processing from sources into the data warehouse.
  • Documenting the various approaches and the pros and cons, the resources and the effort involved, the estimated dates and tentative plan of development, testing and implementation phases for the purpose of decision making on the finalized approach.
  • Designing the architecture for the end to end ETL process. Estimating the resources and ETL effort involved.
  • Ongoing discussions with the BA, data modeler for designing the data mart structure, capturing the dependencies and optimizing the SCD type for each of the table in the data mart.
  • Orientations to the ETL technical team on the architecture, design, approach and development involved in the project on an ongoing basis to facilitate the development phase of the project.
  • Informatica component development of mappings, sessions, and workflows for various ETL jobs using PowerCentre and PowerExchange. Working on automated scheduling of the ETL jobs based on the frequency and the need of the data loads.
  • Designing and developing reusable Informatica components for optimization.
  • Creating Informatica jobs for the whole ETL process of data extraction and load from landing zone to staging area and re extraction and transformation and final load to Data warehouse.
  • Developing of UNIX cron jobs and shell scripts.
  • Implementing push down optimization technique and multithreading in Informatica jobs.
  • Regular performance analysis for checking the bottlenecks and working on redesigns to clear performance bottlenecks.
  • Creating stored procedures in Oracle to be used by Informatica jobs.
  • Data analysis for data quality maintenance.
  • Consolidating requirements based on client discussions, analyzing source data and creating STM (source to target map) documents for ETL processes.
  • Creating design documents for ETL processes and architecture diagrams for data flow across different data marts.
  • Writing technical documents for technical design, system testing and implementation tasks.
  • Informatica jobs code reviews to check for adherence to architectural standards, coding standards and company policies.
  • Leading offshore team, coordinating and assigning day to day tasks and getting development done from offshore.

Confidential, Louisville, Kentucky

Sr. Informatica & SQL Server Developer

Responsibilities:

  • Creating mappings in Informatica, creating and running workflows in Informatica for loading data from flat files to SQLServer tables in EBM module.
  • Updating existing design documents in ETG and CCG modules.
  • Consolidating functional business requirements, designing technical flow documents for EBM module.
  • Analysis of requirements and code development in Netezza for provider data processing, provider ranking in ETG module.
  • Analysis of requirements and code development in SQLServer for EBM module.
  • Code review of Netezza scripts in other modules for requirements discrepancies and standardization process.
  • Data analysis for issues raised in UAT and fixing of the issues in scripts for ETG module.
  • Developing automated scripts for refresh of Netezza tables.
  • Modification of Unix scripts to automate running of Netezza scripts.
  • Analysis of business specific data in flat file form for design and creation of target tables in SQLServer database.

Confidential

Sr. Oracle Developer

Responsibilities:

  • Consolidating functional requirements, creating LLD documents of the module based on interactions with client.
  • Creation of stored procedures to implement core business logics in account receivables and payables sub modules.
  • Creation of stored procedures to generate reports.
  • Done Interfacing of external system with Oracle Financials module.
  • Internal code reviews.
  • Taking module functionality introductory sessions.
  • Taking project internal PL/SQL training sessions for trainees.
  • Worked on Oracle Reports 6i.

Confidential

SAS Developer

Responsibilities:

  • Creating procedures, functions.
  • Working with base SAS, creating SAS macros and SAS stored procedures.
  • Created and published reports in SAS.
  • Created database updating automation script using C# and ADO.NET.

Confidential

Quality Analyst

Responsibilities:

  • Configuration management of the project using Microsoft VSS.
  • Periodic status review of work products.
  • Metrics data collection.
  • Delivery Inspections.
  • Monthly process audits.

We'd love your feedback!