Sr.etl Consultant Resume Profile
CA
Objective:
To obtain a position which leverages my technical expertise and educational background in Data warehousing and OLAP technology.
Summary:
- More than 10 years of experience in IT field as a software engineer in various fields including Federal, Finance, Health insurance and Travel Industry.
- 8 years of experience in Datawarehouse, Datamart and ETL development using InformaticaPowercenter 8.6/ 8.1/ 8.0/ 7.x/ 6.x and Data Integrator 11.7.
- Strong educational background specialized in Computer Applications and Information Technology.
- Extensively worked with Designer, Workflow Manager, Monitor, Repository Manager and Admin Console.
- Self-motivated team player with excellent technical and problem solving skills.
- Self-starter and quick-learner with ability to work independently.
- Dependable team player with strong communication skills and development skills.
Skill Set:
ETL Tools: | InformaticaPowerCenter/Powermart 9.0/8.6/8.5/8.1/8.0 Designer, Workflow Manager, Workflow Monitor, Repository manager and Informatica Server , Debugger, Admin Console, RTM Service, Versioning, Business Objects Data Integrator 2.0, |
Databases: | Oracle 10g/9i/8i,Peoplesoft, MS-SQL Server 2000/5/8, Informix 2.0, DB2, Teradata, Sybase |
Database Tools: | TOAD, SQL plus, SQL Developer, SQL Navigator, Rapid SQL, SQL Server ManagementStudio |
Packages: | Lotus Notes, Sharepoint, MS-Word/Excel/Powerpoint/Outlook/Visio |
Operating System: | WIN 95/98/NT/2000/XP/7/8, UNIX, Linux, AIX, HP-UX, MS-DOS |
Unix Tools: | WinSCP, HP FTP Client, Humming Bird, Exceed, Putty |
Text Editors: | UltraEdit, Notepad , Textpad, Editplus |
Scheduling Tools: | Autosys, DAC, TWS |
Reporting Tools: | Hyperion Smartview, OBIEE Dashboard Reports Analytics, Business Objects Reports Universes Migration |
Models: | Kimball Model, Inmon Model, Star Schema, Snowflake Schema, Facts Dimension Tables |
Others: | Clearcase, Clearquest, Dart, Doors, Remedy, Jira, HTML, XML |
Work Summary
Confidential
Sr.ETL Consultant
- Gather requirements, meet users and understand the business needs.
- Do the complete analysis and provide solution for it.
- Design and develop the solution through ETL and make sure it gets implemented correctly.
- Verify with users and business to confirm if their needs are met.
- Help other junior developers and provide the solutions to them.
- Mentor other developers in implementing the solution through Informatica.
- Help other developers in meeting deadlines.
- Work on long term as well as short term projects which involve ETL as well as CDC solution.
- Coordinating with other teams like Informatica Admin, Unix Admin etc to make them aware of the project, project needs, permissions and accesses.
- Make sure we have all the required accesses and process works accurately.
- Architect the ETL design and solution for project work.
- Fix all the production break fixes, create CCB tickets and make sure that it gets approved.
- Implement the solution with Informatica Admin and production deployment team.
- Create necessary documentation including design, mapping, runbook and scheduling request form.
- Help QA team in testing and understanding the requirements.
- Follow Agile and Scrum process for project and communicate with whole team regarding the status, issue and ETL solutions.
Environment:InformaticaPowercenter 9.0.1, Toad 9.5, Toad 11.6, SQL Server 2008 R2, Oracle 10g, Putty, Flat Files, Exceed
Confidential
Sr. Software Engineer
- Develop ETL/DI mappings, unit test it and make sure it gets implemented correctly all the way to PROD.
- Provide QA, UAT and PROD support.
- Fix ETL defects in DI/DB as well as successfully implement it in other environments.
- Upgraded Data Integrator v2 to Data Services v3.
- Upgraded ETL repository from SQL Server 2005 to SQL Server 2008.
- Setup virtual server on Windows 2008 and installed DS 3.2.
- Migrated the code and upgraded the DI local and central repository on SQL Server 2008.
- Setup virtual client on Windows 7 machine and created the connectivity by troubleshooting many issues.
- Created Job server and configured client and server to make sure that the code is working on upgraded version at both server and client machines.
- Tested heavy data load to make sure that civil and criminal job works and made the management aware of the risk of bad performance.
- Worked on many civil CQ tickets from DEV to its implementation in PROD including its LOE, analysis, design, development, unit testing and deployment in all environments.
- Worked with client to understand the requirements through meetings, discussions and emails.
- Assisting the Govt. employees and documented the CM Configuration Management process workflow as well as provided inputs based on my experience and knowledge in it.
- Analyse the existing system and fix the Clearquest Tickets in DI ETL/Informix DB.
- Gather requirements from business users as well as coordinate with BA regarding business needs.
- Migrate ETL/DI Data Integrator objects from Central Repository to Local Repositories Test/PROD .
- Migrate Reports and Universes / BI Business Intelligence from DEV to TEST and TEST to PROD.
- Coordinate with team for all the test and production deployments.
- Create BIAR files and take the backup for reports and universes.
- Maintain configuration management protocols and keep the clearcase versioning in sync with the PROD environments.
- Make sure that daily production load is completed successfully.
- Mentor junior developers and help them in ETL solutions.
Environment: Business Objects Data Integrator 11.7.3.5, Informix 10, SQL Developer 2005, WinSCP FTP Client, Clearcase, Clearquest, Flat Files, Documentum, DB Visualizer 8.0.8.