SUMMARY

• Has over 9 years of consulting experience in which he has worked mostly with Informatica understanding the 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 help identify solutions and implement technology to achieve the desired solution for most Data warehouses.
• Emeka has also completed the basic MongoDB certification course for Developers.
• Emeka has also completed the basic Big Data course for Hadoop

TECHNICAL SKILLS

• ETL Administration and Development
• Informatica Power Center 8.1, 8.6.1, 9.5,9.6,10.1
• Informatica Power Exchange
• Oracle
• SQL Server Integration Services
• Unix - Shell scripting
• PL/SQL, Stored Procedures
• Teradata/Autosys
• DataStage
• BIG DATA-Hadoop, MongoDB

PROFESSIONAL EXPERIENCE

Sr. Etl developer

Confidential, Dallas, TX

Responsibilities:

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

Sr. ETL Developer

Confidential

Responsibilities:

• Going to different client's site to help solve issues that have 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 the 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

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 knowledge and expertise with team
• HA (High Availability) implementation for Informatica Powercenter 9.6.1
• MDM upgrade implementation to version 9.7.
• Technical documentation of the 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 the projects.
• In charge of all hours worked from team members.
• Understanding on a high level what 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 the ETL project issues they may have.
• Using Apache Hadoop on projects that have decided to use open-source software because it is less-expensive reliable, scalable than other sources out there.
• 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 what kind of data gets loaded into the 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 the 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 the team on what the requirement is and making sure all access is available for them to start work.
• Upgraded to the current version of Informatica and performed all the testing required for a smooth repository flow.
• Talking with the executive team if we have any issue at hand that needs to be fixed immediately.
• Always on call if any tables fail and no one is available to help get the issue resolved before it gets escalated to another level.
• Working with the Informatica PowerCenter Administration Console to provide access to users to do their daily projects.
• Working on repositories that break down, doing a refresh of the current data and doing a "start and stop" of the repository.
• Tickets are sent by a system called Remedy for proper documentation of all work done for each group so as to charge the client appropriately.
• Production support helps early in the morning to help facilitate the runs for the night and make sure all servers and repositories are working in full capacity.
• UNIX log-in using the "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 the right directions and ask required questions for the project at hand.
• Design project using a data model for the 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 the Enterprise Application Integration (EAI) Team within Data Services that enabled integration across the global enterprise.
• Managing the 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 knowledge 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

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 help 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 the mappings and changed the 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 the Remedy Tickets and to follow up with them for its progress

Confidential

Sr. Informatica (ETL) Architect

Responsibilities:

• 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.