Sr. Etl Developer Resume
3.00/5 (Submit Your Rating)
Dallas, TX
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 Confidential 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 (SSIS)
- Unix
- Shell scripting
- PL/SQL, Stored Procedures
- Confidential /Autosys
- DataStage
- BIG DATA - Hadoop
- MongoDB
PROFESSIONAL EXPERIENCE
Confidential, Dallas, TX
Sr. Etl developer
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, Tampa FL
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: Confidential, Confidential .
- 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 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, 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 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