We provide IT Staff Augmentation Services!

Etl Architect/sr Etl Developer Resume

PA

SUMMARY:

  • About 13 years of IT experience with emphasis on Data Warehousing, Business Intelligence, Migration and Integration solutions.
  • Hands on experience with expertise skills in Data Warehouse architecture, Informatica Power Center, Informatica Power Exchange, Oracle and PL/SQL.
  • Extensive experience leading and architecting end - to-end implementation involving design, analysis, development, customization, support, consulting in Data Warehousing and Migration applications.
  • Extensively worked on performance tuning of Informatica Mappings, Sessions, Oracle and Data Warehouse processes.
  • Experience in extracting and loading data from varied sources like Oracle, Teradata, Informix, SQL Server, Flat files and MQ.
  • Worked on Informatica Power Exchange for Oracle CDC writing to heterogeneous targets and other Informatica tools like Test Data Management (ILM), IDQ.
  • Hands on experience in ETL administration, which involves installation and configuration of Informatica Power Center and Power Exchange in Unix and Windows environments, installation of patches, upgrades from 7.1 to 8.6 and 8.6 to 9.5.1.
  • Experience in RDBMS features, Logical & Physical database design including Snowflake and Star schema design and data modeling using ERWIN & ER/Studio .
  • Experience in writing Unix and Perl Shell Scripts for automation of environment builds, deployments, log archiving and scheduling processes using tools like Control M and Autosys.
  • Hands on working knowledge in Oracle and PL/SQL writing Store Procedures, Packages, Functions and Triggers.
  • Practitioner of Agile Methodologies like Scrum (Scaled Agile Framework), Extreme programming and Test Driven Development (TDD).
  • Design, develop, and implement interactive visualizations by analyzing large datasets.
  • Served as mentor and reviewer to developers in all areas of data warehousing, BI and ETL.
  • Excellent communications skills and quick learner with an aptitude for taking responsibilities.

TECHNICAL SKILLS:

BI Tools: Informatica Power Center 7.1.4/8.6/9.5.1, Power Exchange 8.6OWB9i, Cognos BI.

Languages: C, C++, Java, JSP, Java Script, Unix Shell Script, PERL, HTMLPL/SQL.

Data Bases: Oracle 9i/10g/11i, DB2, DB2 UDB, SQL Server, Informix.

Other Tools: Autosys, Control M, Erwin, ER/Studio, Fitnesse, Rally, Informatica

Lifecycle Management tool: Data Masking, IDQ.

PROFESSIONAL EXPERIENCE:

Confidential, PA

ETL Architect/Sr ETL Developer

Responsibilities:

  • Lead team of developers in the design and development of ETL’s for Data warehouse.
  • Partnered with business users and senior management in identifying, prioritizing & features and create ETL Project Plans, BI Road Maps, design and development.
  • Acting as an Informatica SME for all ETL/Informatica related projects and Conduct POC .
  • Responsible for architectural design of ETLs, different ETL load patterns, ETL Framework, ETL error handling and complex mappings to load the data .
  • Participating in the data modeling sessions to understand the data model and providing them inputs based on the existing data to make sure designed model is technically feasible.
  • Involved in complete project life cycle from analysis to production implementation, with emphasis on identifying the source and source data validation, developing and transformation as per the requirement and creating mappings and loading the data into different targets
  • Developed complex mappings using advanced transformations, pushdown optimization, partitioning techniques.
  • Writing test cases and implementing it in Fitnesse and Test Complete.
  • Involved in scheduling jobs using Control M for Data warehouse load.
  • Coach project ETL specialists on data acquisition techniques, decision rules, how to apply them and admin activities.
  • Defining accountability procedures for data governance, processing, storage, retention, reporting and auditing measuring contract compliance.
  • Develop and manage the BI dependency plan, job scheduling and cycle management.
  • Performed SQL and PL/SQL tuning using various tools like Explain Plan, TKPROF and Autotrace.
  • Implemented performance tuning of Informatica mappings, and sessions to provide maximum efficiency and performance.
  • Proficient in designing and modeling of tables for Data warehouse and performance tuning of Oracle queries.
  • Assisted in implementation of high availability Grid implementation, development of disaster recovery strategies and plans including backup plans, recovery procedures and periodic DR drills.

Environment: Informatica Power Center 9.5, Informatica Power Exchange 9.5 (Oracle CDC), IDQ, Cognos 10 BI, Report Studio, Query Studio, Analysis, Oracle 11g, XML, MQ, SQL Server, UNIX Shell Scripting, Windows 2000/NT 4.0, Solaris 5.10, Control M, Tableau, ER/Studio, Scaled Agile Framework, Rally, Test Complete, Fitnesse.

Confidential, PA

ETL Architect

Responsibilities:

  • Lead and guide development of an Informatica based ETL architecture.
  • Develop solution in highly demanding environment and provide hands on guidance to other team members.
  • Design, develop, and implement interactive visualizations by processing and analyzing large datasets.
  • Design and build new data aggregations for ongoing data analysis and statistical modeling.
  • Create logical, physical and dimensional data models (data warehouse data modeling).
  • Head complex ETL requirements and design.
  • Create PL/SQL packages, stand alone procedures, and stand alone functions.
  • Use Collections like variable arrays, nested tables
  • Establish and enforce technical standards for deliverables of projects.
  • Implement an Informatica based ETL solution fulfilling stringent performance requirements.
  • Collaborate with product development teams and senior designers to develop architectural requirements to ensure client satisfaction with product.
  • Develop full SDLC project plans to implement ETL solution and identify resource requirements.
  • Converted SAS programs into Informatica Workflows.
  • Manage build phase and quality assure code to ensure fulfilling requirements and adhering to ETL architecture.
  • Developed complex mappings using different Transformations such as Source Qualifier, Transaction control, SQL Transformation, Java Transformation, dynamic Lookups, Rank, Expression, Router, Filter, Aggregator, and Sequence Generator etc.
  • Configure workflows to run concurrently and written Perl script that generates parameter files based on the input values passed and runs the workflow.
  • Involved in extracting data from flat files, Informix, Sales Force, MS SQL Server, MQ and Oracle database to be used in the mappings.
  • Experience with visual analytics platforms Tableau.
  • Develop mappings using Informatica ILM Test data management tool for data sanitization
  • Automated Informatica jobs in Autosys Scheduler.

Environment: Informatica Power Center 8.6, Informatica ILM Test data Management Tool, Oracle, XML, MQ, SQL Server, UNIX Shell Scripting, Windows 2000/NT 4.0, Solaris 5.10, Autosys Scheduler, Erwin, Tableau, SAS.

Confidential, PA

ETL Lead

Responsibilities:

  • Worked with business analysts to gather business requirements, reviewed the business requirements and created high level design for Informatica Workflows.
  • ETL Tech Lead for onsite and offshore team of ETL Developers.
  • Partnered with business users in identifying, prioritizing & resolving numerous data issues, create ETL Project Plans, design and development.
  • Assigned the work to development team by creating the individual tasks and updating the status to the project managers.
  • Involved in complete project life cycle from analysis to production implementation, with emphasis on identifying the source and source data validation, developing and transformation as per the requirement and creating mappings and loading the data into different targets
  • Developed complex mappings using different Transformations such as Source Qualifier, Transaction control, SQL Transformation, Java Transformation, dynamic Lookups, Rank, Expression, Router, Filter, Aggregator, and Sequence Generator etc.
  • Used Session parameters, Mapping variable/parameters.
  • Configure workflows to run concurrently and written Perl script that generates parameter files based on the input values passed and runs the workflow
  • Involved in extracting data from flat files, MS SQL Server, MQ and Oracle data base to be used in the mappings.
  • Developed Reusable Transformations, Shortcuts & Mapplets and used them in the Mappings
  • Created Extract maps and Power Exchange Workflows for real time data movements which writes to heterogonous target like oracle and MQ's
  • Automated the creation of Extract maps for Power Exchange.
  • Written scripts to find the latency of Power Exchange workflows.
  • Implemented performance tuning of mappings, and sessions to provide maximum efficiency and performance

Environment: Informatica Power Center 7.1.4/8.5, Informatica Power Exchange5.2.2/8.5 (Oracle CDC), Oracle, XML, MQ, SQL Server, UNIX Shell Scripting, Windows 2000/NT 4.0, Solaris 5.10.

Confidential, PA

Informatica Administrator

Responsibilities:

  • Worked as Informatica Administrator involving Informatica Power Center and Power Exchange Installation and configuration on Solaris.
  • Handle user access / security role requests for new developers and projects
  • Installation and maintenance of all necessary updates and/or patches for the ETL environments
  • Involved in Beta testing of Informatica 8.5 version.
  • Setup and maintain ETL administration best practices and procedures
  • Automated the installation/build of different Informatica environments such as IT, QA, Implementation, Production and ETL Deployments.
  • Upgraded Informatica Repositories from 7.1.4 to 8.5 version
  • Designed and developed UNIX and PERL shell scripts as part of admin activities to Start/ Stop Informatica Services, Starting Informatica workflow, Logs archiving and other scripts for ETL Process
  • Performed the capacity planning required to create and maintain environments.
  • Assisted in implementation of high availability Grid implementation, development of disaster recovery strategies and plans including backup plans, recovery procedures and periodic DR drills.

Environment: Informatica Power Center 7.1.4/8.6, Informatica Power Exchange5.2.2/8.6 (Oracle CDC), Oracle, XML, MQ, SQL Server, UNIX Shell Scripting, Windows 2000/NT 4.0, Solaris 5.10.

Confidential

ETL Developer

Responsibilities:

  • Write the connectors, Write the ETL specification, create oracle procedure, Create DTS Packages, Create Analytics/report using oracle discoverer.
  • Designed the ETL Specification for Source System to STG and STG to DW.
  • Implemented the ETL processes using OWB to load data from sources system into the staging.
  • Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
  • Developed mappings using OWB for data loading. Created Process flow, scheduled & monitored session.
  • Create Analytics and dash board analysis using oracle Discoverer.

Environment: Oracle Warehouse builder 9i, SQL, PL/SQL, Erwin, TOAD.

Confidential, NY

Informatica Developer

Responsibilities:

  • Business requirements gathering, analyzing the source data coming from different databases and working with business users and developers to develop the model
  • Provided different design strategies for the process
  • Extracting, Scrubbing and Transforming data from Flat Files, Oracle, SQL Server and then loading into Oracle database using Informatica.
  • Worked with different transformations for loading the data into target such as Source Qualifier. Joiner, Update Strategy, Lookup, Rank, Expression, Router, Filter, Aggregator
  • Modified the existing Mappings and created new Mappings as per the requirement
  • Tuned performance of the mappings by optimizing the expression editor/transformations, Informatica functions, filtering the source data at the source qualifier and increasing the DTM buffer size
  • Extensively used the Informatica Debugger to identify and fix data problems
  • Defined Target Load Order Plan and constraint based loading for loading data into Targets.
  • Involved in Unit Testing, System testing, Integration testing and debugging the errors during testing.
  • Managed Change control implementation and coordinating daily, monthly releases and reruns
  • Performed various Informatica Administrative tasks and managed the local repositories and permissions using Repository Manager in Oracle Database
  • Configured Informatica Servers and automating the manual process using UNIX Shell scripts
  • Dealt with the loading of huge volumes of data (History loads, delta loads, weekly loads, monitored the loads and provided support initially.

Environment: Informatica Power Center 7.1.3, Oracle, XML, MQ, SQL Server, UNIX Shell Scripting, Windows 2000/NT 4.0

ETL Developer

Confidential

Responsibilities:

  • Used Informatica Power Center 6.2/5.1.1 to extract, transform and load data from multiple input sources like flat files, sequential files into DB2
  • Created data flow diagrams in MS Visio to document Informatica mappings, various processes and workflows.
  • Worked on Source Analyzer, Warehouse designer, Mapping & Mapplet Designer and Transformations, Informatica Repository Manager and Workflow Manager and Monitor.
  • Created Mappings, Mapplets and Transformations using the Designer and developed Informatica sessions as per the business requirement.
  • Tuned the Informatica mappings for better performance.
  • Used most of the transformations such as the Source qualifiers, Routers, Filters, Sequence Generators and Expression as per the Business requirement.
  • Used Workflow Manager for creating and maintaining the Sessions. Administrated Workflow Manager to run Tasks and Worklets
  • Involved in debugging of the complex mappings and analyzed the workflow logs.
  • Extensively used almost all the transformations such as Update Strategy, Stored Procedure, Cached lookups, Connected and Unconnected lookups, Filter, Router, Expression, Aggregator, and Joiner etc.
  • Created tasks, sessions and workflows and database connections, scheduled and monitored transformation processes using Informatica server manager.

Environment: Informatica Power Center 6.2/5.1 (Designer, Workflow Manger, Workflow Monitor and Repository Manager), DB2, SQL, PL/SQL, Erwin, TOAD

Hire Now