Etl Tech Specialist Resume
Little Rock, AR
SUMMARY
- Dynamic and highly motivated ETL/Data warehousing professional with more than 10 years of experience and expertise in Ab Initio/Datastage/Informatica
- Experience with ETL integration with Hadoop/Big data (Integration of ETL project to Data Lake)
- Knowledge of Big Data/Hadoop (map - reduce framework), Pig, Hive, HBase
- Proven experience as a team member/module lead in development and support of data warehouse applications
- Thorough knowledge of UNIX commands and Certified in Oracle PL/SQL and IBM Datastage v8.5
- Expert level skills in all phases of software development, including RDBMS concepts, databases (Oracle, Teradata, DB2), query analyzing, performance tuning
- A strong record of success, working both independently and with multidisciplinary groups
- Demonstrated talent for organizing and directing teams in an efficient and effective manner
- Energetic self-starter with excellent analytical and organizational skills along with substantial troubleshooting experience
TECHNICAL SKILLS
ETL tools: Ab Initio, Metadata Hub, Datastage, Informatica
Programming: C, C++, Core Java, Hadoop (MapReduce)
Scripting: Unix shell scripting, Pig/Hive/Sqoop/HBase
Other Utility Tools: Toad, Quality Center, SQL Developer, Aginity, IBM Initiate 8, Inspector, SOAP UI, winscp, putty
Database Systems: Oracle, DB2, Teradata, Netezza
Scheduling tools: Autosys, TWS (Tivoli Workload Scheduler), Control-M, CA7
Operating Systems: Windows 98/XP, Windows NT 4.0, Windows 2000 and Linux
PROFESSIONAL EXPERIENCE
ETL Tech Specialist
Confidential, Little Rock, AR
Responsibilities:
- Analyzed the data structure and meaning in both the source and the target BI systems
- Designed and specified source data detection, cleansing and extraction processes and loaded in staging to apply transformation before loading into DWH tables
- Created source/target mappings and apply business rules as per transformations for populating the data warehouse for everyday reporting needs
- Designed ETL processes in generic data model to accommodate changes in source systems and new business user requirements with minimal changes
- Prepared generic ETL data model for each requirement to provide the data in Fact and Aggregate tables for Cognos reporting wireframes and reports
- Defined and captured metadata and rules associated with ETL processes
- Coordinated with program-level ETL architect to ensure compliance with standards and consistency with long-term infrastructure plans
Environment: Informatica Power Center 9.6.1, IBM Curam 7, UNIX, Putty, DB2, Jira, JAMA, IBM Cognos, Winscp, Toad
ETL Technical Specialist
Confidential, Atlanta, GA
Responsibilities:
- Documented all technical and system specifications/requirements for all existing ETL processes and created a new design by maintaining a do-no-harm approach to existing downstream consumers
- Centralized metadata capture and ensured E2E lineage in MHUB while maintaining the Enterprise data governance
- Worked closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs met the existing business and data requirements
- Provided generic architecture for all application processes to ensure maximum reusability of code
- Conducted existing code rationalization and modification to ensure better performance in new environment and integrated the code with HDFS file system for source and target load ready file
- Built the code and facilitated migration for QA environment and matching the test harness of target load ready files between existing system and load ready file generated in new environment
- Performed root cause analysis on issues raised during QA/UAT/PROD phases, provided resolutions/validation for all issues and performed routine support to all ETL applications under warranty phase
- Responsible for defect meeting coordination and supported the application until cutover
Environment: Ab Initio, MHUB, Control Center, Conduct>it, UNIX, HDFS framework, Putty, DB2, Oracle, SQL, Mainframe, CA7 scheduler
ETL Technical Specialist
Confidential, Phoenix, AZ
Responsibilities:
- Created all technical and system specifications documents for all ETL processes and assisted in the ongoing development by ensuring best practices for data movement, data quality, data cleansing and other ETL-related activities
- Provided technical knowledge of Extract/Transform/Load (ETL) solutions for Business Intelligence projects
- Worked closely with project Business Analyst, Data Modeler and BI Lead to ensure that the end to end designs met the business and data requirements
- Managed onsite communications and co-ordination with clients on business requirements
- Participated in quality assurance walk-through of ETL processes and supported development teams with performance tuning and troubleshooting issues
- Worked closely with Project Manager to develop and update the task plan for ETL work and to keep the manager aware of any critical task issues and dependencies on other teams
- Ensured that the ETL code delivered conformed to specifications and design guidelines
- Provided metadata hub support for E2E lineage of system applications
- Performed root cause analysis on issues raised during QA/UAT/PROD phases, provided resolutions/validation for all issues and performed routine support to all ETL applications under warranty phase
Environment: Ab Initio, Datastage, MHUB, Control Center, Conduct>it, Unix, Putty, DB2/Teradata, Control-M Scheduler
ETL Technical Lead
Confidential, Northbrook, IL
Responsibilities:
- Served as a Program Technical Lead and was responsible for designing the ETL strategy and architecture of the Project.
- Managed tasks and deadlines for the ETL teams both onsite and offshore
- Was the point person on the ETL team for other teams such as Reporting, Testing, QA and Project Management for updates on project status and issues
- Solicited functional requirement specifications from business users
- Broke up the workload in to task lists and estimates based on simple, medium and complex methodology
- Provided high level and low level ETL flow design
- Provided functional KT for the QA team
- Conducted review of ETL Code, Unit Test Cases and results with the developers
- Organized daily technical discussions with the onsite team and the individual offshore work stream leads and set expectations for offshore delivery
- Involved in POC and provided client proposals for new initiatives
Environment: Ab Initio, Control Center, Conduct>it, Unix, Putty, Oracle, DB2, Teradata, Hadoop