Senior IDQ/ETL Lead / Architect Resume TX - Hire IT People

SUMMARY:

Professional with more than 17+ years of overall IT experience in the implementation of IT projects, expert in leading and contributing to projects designed to enhance system functionality and end - user productivity.
Extensive 9 years of ETL experience in Data warehousing ETL tools Informatica Power Center and IDQ.
Worked with various sources and target systems like Flat Files, CSV files, Oracle, DB2 and Teradata using Informatica Power Center 8.x/9.x (Repository Manager, Mapping Designer, Workflow Manager, Mapplet Designer, Workflow Monitor, Source Analyzer, Transformations Designer, Warehouse Designer).
Proficiency in data modeling concepts such as Star Schema/ Snowflake modeling, fact and dimension tables, physical and logical data modeling.
Handled high volume data loads in multi-threads and into the transaction, OLTP and OLAP repositories.
Hands-on experience working with RDBMS like DB2 UDB, Oracle and SQL server and Teradata.
Strong UNIX shell scripting experience and automating Informatica jobs and scheduling using TWS.
Experience leading and mentoring development teams with performance tuning and job optimizations.
Strong knowledge and experience with full lifecycle development methodologies, standards and procedures. Knowledgeable and experienced in data modeling including dimensional modeling techniques.
Ability to multi-task and work independently with good analytical and problem solving skills.
Acknowledged for capacity to tackle challenging issues, analyze viable alternatives, and provide innovative solutions that reside well within clients’ financial and time frameworks.

TECHNICAL SKILLS:

Operating Systems: DOS, Windows, Linux Red Hat 9.0, Solaris, HP-UX, Aix and Mac, Android

ETL Tools: Informatica Power Center 8.x/9.x( Designer, Workflow Manager, Workflow Monitor, Repository manager, Informatica Administration Console),Informatica Meta Data Manager,Power Exchange 8.x/9.x, Informatica Data Quality 9.x(Informatica Developer, Informatica Analyst,Admin Console, Monitoring console)

Databases: Oracle 12c, DB2, SQL Server 2000, PostgreSQL 8.1, MS Access, Teradata

Language: C, C++ and Java, VB, SQL.

Web Technologies: HTML 4.0, JavaScript, CSS

J2EE Technologies: Servlets 2.3, JSP 2.0, Java Beans, JDBC, JXL., JMS

Frameworks: Tiles, Struts, Spring and Hibernate Framework

Configuration Tools: MS Visual Source Safe, CVS, SVN, Perforce, Share point, CA Harvest SCM

Bug Tracking Tools: PVCS Tracker, Seibel, Pivotal, Mantis, Bugzilla, Rational Team Concert

Other Tools: Ant, VMWare, Test DirectorApp/Web Servers: Weblogic, Websphere, Tomcat 4 and above.

Service Management Tools: Service Now

PROFESSIONAL EXPERIENCE:

Confidential, TX

Environment: Informatica 9.6.1, IDQ, Oracle 12c, Linux, Android GUI

Senior IDQ/ETL Lead / Architect

Responsibilities:

Prepared a business requirements and design document for the project.
Planned and formulate effective technical indicators and make profitable trading strategies.
Create plans for adding buy and sell signals and bidding engine capability.
Involved in design and creation of the new data ware house and its data marts and worked on data feed loads, data extracts etc.
Prepared the design documents, Source to Target mapping sheet, Unit Test Plans, Code review checklists, Deployment activities.
Developed the mapplets/rules in IDQ to apply data quality rules, perform cleansing, standard code values for source system data.
Extensively created and used physical data objects, logical data objects, reference tables, reference files like dictionaries.
Developed the mappings, workflows, data services(web services, SQL services), Applications, DQ Rules/mapplets in IDQ to fetch the data from various sources into staging tables, apply DQ rules, transformation logics and load the transformed data in the Oracle 12c data ware house.
Developed the mappings, mapplets, workflows, tasks in Informatica Power Center to read the data from Flat Files, CSV files apply the transformations and load the data to data ware house.

Confidential,Richardson, TX

Environment: IBM Datastage 9.1, DB2, Teradata 14, UNIX, IBM Mainframe, Zena scheduler

Senior ETL Lead / Architect

Responsibilities:

Prepared the designed document for ETL and Reporting systems.
Gathered requirement and technical document to implement the application.
The sensitive data of the customers were masked and encrypted.
Created ETL jobs for Migration services and Data Integration.
The new mappings were developed using Look Up/Aggregation transformations to match the needs of the business case.
Used control flow tasks in SSIS and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
The data migrations of both American Airlines and Golden Living in ODS and ADW systems.
Captured technical metadata through data modeling tools.

Confidential,Richardson, TX

Environment: IBM Datastage 9.1, SQL Server, Teradata 14, Zena scheduler

Senior ETL Lead / Architect

Responsibilities:

Involved in design of dimensional data model - Star schema and Snow Flake Schema
Worked on DB scripts and Creation of physical tables in database
Worked SCDs to populate Type I and Type II slowly changing dimension tables from several operational source files
Created some routines like Before-After and Transform function and used across the project.
Worked on complex Flat File stage, DataSet stage, LookUp File Stage, Sequential file stage.
Implemented Shared container for multiple jobs for same job as per requirements.
Good knowledge and experience in mapping source to target data.

Confidential, Irving, TX

Environment: Informatica 9.1, DB2, Teradata, SQL, PL/SQL, Toad, Harvest, SQL Loader, TWS Enterprise Scheduler, Linux, Flat files, Mainframe datasets

Responsibilities:

Co-ordinated Joint Application Development (JAD) sessions with Business Analysts and source developer for performing data analysis and gathering business requirements.
Developed technical specifications of the ETL process flow
Designed the Source - Target mappings and involved in designing the Selection Criteria document.
Worked on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in DB2 and Teradata.
Used Informatica Power Center to create mappings, sessions and workflows for populating the data into dimension, fact, and lookup tables simultaneously from different sourcesystems (SQL server, Oracle, Flat files).
Created mappings using various Transformations like Source Qualifier, Aggregator, Expression, Filter, Router, Joiner, Stored Procedure, Lookup, Update Strategy, SequenceGenerator and Normalizer.
Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
Used version mapping to update the slowly changing dimensions to keep full history to the target database.
Involved in migration of Informatica from 8.x to 9.x.
Implemented sending of Post-Session Email once data is loaded.
Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
Used Debugger to test the mappings and fixed the bugs.
Tuned performance of mapping and sessions by optimizing source, target bottlenecks and implemented pipeline partitioning.
Worked with DBA for partitioning and creating indexes on tables used in source qualifier queries.
Involved in Performance/Query tuning. Generation/interpretation of explain plans and tuning SQL to improve performance.
Scheduled various daily and monthly ETL loads using Control-M
Involved in writing UNIX shell scripts to run and schedule batch jobs.
Involved in unit testing and documentation of the ETL process
Involved in Production Support in resolving issues and bugs.

Confidential,Irving, TX

Environment: Java, Spring MVC 2, DB2, Weblogic, JMS, JDBC

Project Lead / Project Coordinator

Responsibilities:

Discuss the requirement for proposal (RFP) from the client with the team.
Setup meeting with client to get clarifications on RFP and letting them know project assumptions.
Work the sales team with technical details and prepare proposals.
Proposal presentations to key decision makers, effectively sell the capabilities and credentials of organization.
Prepare high level project plan for the management and work with the engagement manager to come up with the cost estimates.
Provide demos to various groups to make them aware of the new development approach.
Provide weekly status report to the client and management.
Responsible for handling Web-Participation, Net Meeting, Video conferencing and voice conferencing with project teams.
Review requirement specifications and analyze processes and user needs.
Prepare and review the architectural design of the system and document it.
Discuss the project requirements with the team members.
Work closely with the offshore team to build up the development and testing environment.
Work with the client admin team to build up the network support for the offshore.
Work on project development, testing and implementation.
Perform the periodic performance assessment and evaluation of the team members and provide the report to senior management.
Provide technical support to the sales force when required.

Confidential,Irving, TX

Environment: Java, Spring MVC 2, DB2, Weblogic, JMS, JDBC

Project Lead / Project Coordinator

Responsibilities:

Discuss the requirement for proposal (RFP) from the client with the team.
Setup meeting with client to get clarifications on RFP and letting them know project assumptions.
Work the sales team with technical details and prepare proposals.
Proposal presentations to key decision makers, effectively sell the capabilities and credentials of organization.
Prepare high level project plan for the management and work with the engagement manager to come up with the cost estimates.
Provide demos to various groups to make them aware of the new development approach.
Provide weekly status report to the client and management.
Responsible for handling Web-Participation, Net Meeting, Video conferencing and voice conferencing with project teams.
Review requirement specifications and analyze processes and user needs.
Prepare and review the architectural design of the system and document it.
Discuss the project requirements with the team members.
Work closely with the offshore team to build up the development and testing environment.
Work with the client admin team to build up the network support for the offshore.
Work on project development, testing and implementation.
Perform the periodic performance assessment and evaluation of the team members and provide the report to senior management.
Provide technical support to the sales force when required.

Confidential,Irving, TX

Environment: Java, Spring MVC 2, DB2, Weblogic, JMS, JDBC

Project Lead / Project Coordinator

Responsibilities:

Discuss the requirement for proposal (RFP) from the client with the team.
Setup meeting with client to get clarifications on RFP and letting them know project assumptions.
Work the sales team with technical details and prepare proposals.
Proposal presentations to key decision makers, effectively sell the capabilities and credentials of organization.
Prepare high level project plan for the management and work with the engagement manager to come up with the cost estimates.
Provide demos to various groups to make them aware of the new development approach.
Provide weekly status report to the client and management.
Responsible for handling Web-Participation, Net Meeting, Video conferencing and voice conferencing with project teams.
Review requirement specifications and analyze processes and user needs.
Prepare and review the architectural design of the system and document it.
Discuss the project requirements with the team members.
Work closely with the offshore team to build up the development and testing environment.
Work with the client admin team to build up the network support for the offshore.
Work on project development, testing and implementation.
Perform the periodic performance assessment and evaluation of the team members and provide the report to senior management.
Provide technical support to the sales force when required.