AB Initio/ETL Developer Resume Boston - MA - Hire IT People

PROFESSIONAL SUMMARY

Around 6 years of IT experience in Data Warehousing and Data Base technologies wif entry level knowledge in Business intelligence and Data Science.
Excellent experience wif analysis, design, development, customizations and implementation of Data Warehousing, Data Integration & information management applications.
Strong Ab Initio skills including various Ab Initio modules like GDE, EME, Conduct>IT, Express>IT etc.
Well versed wif various Ab Initio parallelism techniques and both batch and continuous flow processing.
Proficient in analyzing and translating business requirements to technical requirements and architecture
Familiar wif scheduling tools like Control - M and AutoSys to run and monitor ETL jobs.
Good experience in UNIX and shell scripts
Knowledge on the phases of Agile methodology.
Strong Relational database development skills using SQL, PL/SQL, Oracle, Teradata.
Familiar wif other ETL tools like Oracle Data Integrator, Talend, SSIS etc.
Experience implementing projects using BI tools such as Tableau, Spotfire, QlikView, QlikSense and Excel Power Pivot.
Hands on experience in project planning, estimation, resource planning and project management.
Extensive people management and leadership skills.
Result-focused wif strategic foresight, clarity and exceptional documentation.
Self-motivated individual wif good communication and interpersonal skills, as well as team player.

TECHNICAL SKILLS

ETL/ELT Tools: Ab Initio, Talend, Oracle Data Integrator, SSIS

Databases: Oracle 12C, MySQL, Microsoft SQL Server 2014, Teradata v13.0

Data: Modeling Rational Rose

Programming: C++, PL/SQL

Operating System: UNIX/Linux

Reporting: Tableau, Spotfire, QlikView, QlikSense, Excel Power Pivot

Other Tools: SPSS, Microsoft Azure, Visio, Control M, AutoSys

WORK EXPERIENCE

Confidential, Boston - MA

AB Initio/ETL Developer

Responsibilities:

Lead Designer and the Primary Ab Initio Developer on the New POS Project.
Plan, Estimate, Co-ordination wif teams, Code Review, Work status tracking, Client communication, Production release & implementation.
Have discussions wif the client and freeze the high and low level requirements
Help the team understand the requirements and guide them in the development and testing phases.
Mapping new XML elements to the old XMLs and creating mapping document for the same
Being involved in all the phases of the project and making sure that deadlines are met wif utmost quality deliverables by adhering to quality procedure as laid out by the client.
Utilized continuous flow processes wif multi queues and Conduct
Supervised the analysis, development and testing of ETL jobs.
Generating SQL code to dump ETL output into target database.
Developed several generic ETL jobs to be used across various projects to help all teams to access data faster.
Getting actively involved in all the phases of project.
Create and maintain the defect report sheet.

Confidential

Ab Initio/ETL Developer

Responsibilities:

Served as the primary offshore Ab Initio developer on all three projects simultaneously.
Analyzed different source systems and created Source to Target Mapping documents.
Implemented ETL jobs using Multi File Systems to process data in parallel theirby optimizing the jobs.
Research performance issues and optimize graphs for better performance and resource usage using parallelism techniques and lookups.
Designing Data Warehouse schemas based on dimension modelling techniques and writing CREATE statements to build fact and dimension tables.
Created numerous queries involving various types of joins, subqueries, CTE’s etc for diverse business requirements.
Reviewed Data/Process Flow designs and codes of team members to ensure high quality of deliverables.
Scheduled batch graphs and plans using Control M and Autosys

Confidential

AB Initio Developer

Responsibilities

Converted critical code from Teradata stored procedures to Ab Initio ETL jobs.
Prepared/reviewed low level design documents and data validation sheets Created generic ETL jobs to extract data from legacy systems to stage before cleansing and loading it into data warehouses.
Coordinated wif Teradata DBAs for optimizing SQL code.
Developed design documents and migration sheets to promote the changes to production.
Performed unit and integration testing to validate the target tables.
Writing SQL scripts to create/update/populate target database objects like tables, views etc from various source databases.
Writing FastLoad, MLoad and TPump scripts in Teradata to populate target tables from ETL output flat files.