PROFESSIONAL SUMMARY:

• TEMPHas over 9 years of consulting experience in which he TEMPhas worked mostly with Informatica understanding teh whole ETL life cycle.
• His jobs roles are as follows: Project Manager, Informatica developer, Sr. Informatica Architect, ETL Lead and Informatica Administrator.
• He also worked as a Teradata consultant, Emeka possess a strong ETL background that will halp identify solutions and implement technology to achieve teh desired solution for most Data warehouses.
• Emeka TEMPhas also completed teh basic MongoDB certification course for Developers.
• Emeka TEMPhas also completed teh basic Big Data course for Hadoop

TECHNICAL SKILLS

• ETL Administration and Development 12 Years
• Informatica Power Center 8.1, 8.6.1, 9.5,9.6,10.1 12 Years
• Informatica Power Exchange 5 years
• Oracle 13 Years
• SQL Server Integration Services (SSIS) 8 Years
• Unix - Shell scripting 8 Years
• PL/SQL, Stored Procedures 7 Years
• Teradata/Autosys 5 Years
• DataStage 2 Years
• BIG DATA-Hadoop, MongoDB1 Year

PROFESSIONAL EXPERIENCE

Sr. Etl developer

Confidential, Dallas, TX

Responsibilities:

• Managing a Production support team to monitor daily scheduled jobs
• Teaching teh team about Informatica and giving them an in-depth noledge of best-practice in achieving almost 0% manual work and having all scheduled runs automated
• Hands on work fixing teh scheduler(Maestro) to ensure speedy runs of daily jobs.
• Creating DataStage jobs for new projects assigned to my team
• Code review with teh team to ensure teh development jobs meet teh standards before it is migrated to teh production environment.
• Monitoring of weekend jobs bi-weekly
• Allocating teh resource needed for new Project and seeing that teh project is completed
• Scheduling daily meetings to no where improvement is needed.
• Control-M scheduler is used for a different project for another Client for Datastage jobs

Sr. ETL Developer

Confidential, Tampa FL

Responsibilities:

• Going to different client's site to halp solve issues that has anything to do with ETL.
• Hand-on experience with Implementing Informatica Data Quality, Web Services, and Informatica Real-time
• Batch scripts for file management
• Working with different technical teams to ensure steady flow of all ETL processes.
• Some of teh Clients are as follows: Tiffany& Co, Staples.
• Designed Batch Processing system for applications using AutoSys. Developed standardized scripts for job implementation
• Doing some Open source MongoDB POC (Proof of Concept) with Informatica Power Exchange.
• Using Confidential Clear-Quest to receive request and grant privileges.
• Working with Confidential Data-Studio (Version 4.1.1) for daily tasks to complete work on tables.
• Running CDC with informatica PowerExchange to receive near real-time data for weekly analysis.
• Creation of Informatica Mappings, Workflows, sessions and Run those Sessions to load into Target tables.

Confidential Seattle, WA

ETL Lead/Technical Lead

Responsibilities:

• Admin work on all servers Prod, Dev, and Test.
• Provide technical leadership through Informatica Power Center ETL design & development for ODS and Enterprise Data Warehouse
• Provide recommendations for re-usable design patterns
• Troubleshoot batch failures to determine cause (review AutoSys logs) and correct/escalate
• Provide input & vision to ETL development standards and guidelines
• Lead teams of technical staff (Oracle and Informatica) for ETL architecture, design, development, unit testing, deployment and short-term warranty support
• Lead by example
• Demonstrate a positive attitude and team focus
• Share noledge and expertise with team
• HA (High Availability) implementation for Informatica Powercenter 9.6.1
• MDM upgrade implementation to version 9.7.
• Technical documentation of teh full deployment process of all Powercenter environments from Dev to Test to Pre-Prod and Prod.
• In charge of all SLA projects going on with my team and communications with PMs of all projects assigned.
• Writing up estimates for projects and getting resources from both off-shore and on-shore to complete teh projects.
• In charge of all hours worked from team members.
• Understanding on a high level wat projects each team member is working on and able to explain it to any PMs that need clarifications.

Confidential

ETL Developer/Engineer /Lead

Responsibilities:

• Working at different Client locations to solve teh ETL project issues they may has.
• Using Apache Hadoop on projects that has decided to use open-source software coz it is less-expensive reliable, scalable than other sources out their.
• Scheduling jobs from Control M, Tidal and unix cron
• Deployments of nodes from DEV to UAT/TEST to PROD, folder to folder copy, export as xml files, server to server copy
• Repository creation - in UAT/ PROD through admin console.
• Repository backup - using PMREP for Informatica Command line, manual backup through admin console.
• Production support on call bi-weekly for monitoring Services of Windows Server and Unix Server.
• Developer mappings form different sources like
• Data Quality Administration to verify wat kind of data gets loaded into teh datawareouse.
• Using SSIS Wizard to quickly move data from a variety of source types to a variety of destination types, including text files and other SQL Server instances.
• Writing batch scripts to FTP and IP address configurations
• Using Informatica scheduler including 3rd party scheduler like TIDAL, Autosys, Control M. Worked on teh Environment: AutoSys 4.5.1
• Also Informatica upgrades of Hot fixes (9.1/8.6.1 / 8.6.12/ 8.6.14 ETC) and patches

Confidential, Chicago Illinois

ETL Lead/Administrator

Responsibilities:

• Educating teh team on wat teh requirement is and making sure all access is available for them to start work.
• Upgraded to teh current version of Informatica and performed all teh testing required for a smooth repository flow.
• Talking with teh executive team if we has any issue at hand that needs to be fixed immediately.
• Always on call if any tables fail and no one is available to halp get teh issue resolved before it gets escalated to another level.
• Working with teh Informatica PowerCenter Administration Console to provide access to users to do their daily projects.
• Working on repositories that break down, doing a refresh of teh current data and doing a "start and stop" of teh repository.
• Tickets are sent by a system called Remedy for proper documentation of all work done for each group so as to charge teh client appropriately.
• Production support halps early in teh morning to halp facilitate teh runs for teh night and make sure all servers and repositories are working in full capacity.
• UNIX log-in using teh "super user"(SU) to log-in and work on servers and do refresh and migrations needed for continuous improvement.

Confidential

Informatica Developer/Administrator

Responsibilities:

• Interpret and comprehend business / data requirements and form upstream processes
• Attend weekly meetings with BA's to ensure project is heading to teh right directions and ask required questions for teh project at hand.
• Design project using a data model for teh development and gave best practice advice to Client on best way to improve performance.
• Document technical requirement specifications and detailed designs for ETL processes of moderate and high complexity
• Create and document source-to-target mappings and ETL specifications
• Design ETL processes for optimal performance

Confidential, Bartlesville OK

Sr. Informatica Developer

Responsibilities:

• A member of teh Enterprise Application Integration (EAI) Team within Data Services that enabled integration across teh global enterprise.
• Managing teh transformation, delivery, and exchange of data between both internal and external business systems across all business units - Upstream, Downstream, Commercial and Corporate using Informatica.
• Working with team members to provide system support, documentation, and noledge sharing of best practices
• Worked on building data warehouses and working with an Enterprise Data Warehouse
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), and SQL Server Integration Services (SSIS) (2005/2008).
• An Oil and Gas Industry Experience.

Confidential, Atlanta GA

Sr. Informatica Developer

Responsibilities:

• Using Informatica 8.1 Power Center for daily ETL Process and development of new data.
• Using a budget of $17million dollars to halp design a new process of Data Integration and performance tuning.
• Creation of hundreds of mappings and extensive testing of data before data is sent to production.
• Peer review" to make sure all connections are correct and no accident are made to run on production before roll-out date.
• Use of past experience to maximize data flow, performance tuning, workflow performance, mapping performance, etc.

Confidential, Birmingham, AL

Informatica Administrator/Developer/DBA

Responsibilities:

• Convert identified Microsoft SQL Server 2000 DTS jobs to Informatica Power Center 9.x
• Support and troubleshoot existing Informatica Power Center workflows
• Support testing and deployment activities for Data Services
• Check/checkout in teh mappings and changed teh version of that mapping.
• Create stored procedures and cursors, for dropping indexes at target level
• Schedule sessions and batch process based on demand, run time, run only once using Informatica Server Manager and Scheduled Multiple sessions
• Transformed data from one server to other servers using SQL Server Integration Services (SSIS)
• To interact with Offshore Team everyday using IM and Conference CALLS, and assign them work, based on teh Remedy Tickets and to follow up with them for its progress

Confidential, VA

Sr. Informatica (ETL) Architect

Responsibilities:

• Worked for teh US Customs and Border patrol (CBP) on a 3month contract and my job duties included teh following:
• Responsible for technical design documentation
• Collaborate on technical solutions with application architects, product managers and architecture teams.
• Follow established enterprise development and design standards, guidelines and processes.
• Create high-quality technical documentation
• Interact with IT management and other teams at a highly professional and technical level
• Provide high-quality consultation to business partners and demonstrate keen aptitude in acquiring business domain expertise.
• Ensure deadlines are met, yet be forthright on progress and flexible
• Ensure that all best practices and enterprise standards are followed.