SUMMARY

• Over 14 years of experience in Information Technology with strong emphasis on
• Data Warehouse and Business Intelligence platforms.
• Efficient interpretation of business needs to draft transformation rules and ETL /BI design documents and to educate the team with the technical design specs.
• Active participation in the design of Star schema & Snowflake schema architectures
• Strong hands on experience in using Informatica PowerCenter 9.X/8.X/7.X.
• Expertise in designing complex Mappings, Workflows and Sessions for extractiontransformation and loading data.
• Implementation of Change Data Capture (CDC) logic from various source platforms.
• Worked on DB2, Flat files, XML, SQL Server, Oracle, Vertica, Teradata, TPT, Fload and
• Mload utilities and Sybase databases.
• Hands on experience in the development of Error Handling Strategies for ETL
• Processing and processing unstructured files in a Big data platform.
• Active participation in Performance Tuning of the SQL queries and ETL Mappings through DB partitions and partition points.
• Active participation in review meetings involving Project managers, QA analystsDBA, Data Modelers and BI Architects.
• Efficient in delivering projects via Agile and scrum methodologies.
• Efficient in documentation of technical design specifications, Source to target specifications, Release Notes, Run book, Playbook and ETL Process flow diagrams
• Good understanding of OLAP and OLTP systems
• Hands on experience of UNIX Shell scripting, MQ and SFTP processes
• Knowledge of Inmon and Kimball methodologies of Data warehousing
• Experience in creating PL/SQL Stored procedures and packages
• Proficient in analyzing requirements and conducting Unit testing and UAT
• Active participation in Production deployment of ETL, UNIX and Control - Mcomponents
• Leadership qualities with emphasis on individual and team efforts backed by goodcommunication skills

TECHNICAL SKILLS

ETL Tools/Packages: Informatica PowerCenter 10.2/ 9.6/8.6/7. X, ODI

Reporting Tools: Cognos 10, Power BI,BO 3.1

Data Modeling Tools: ER Studio, Erwin

Querying Tools: SQL Query Analyzer 2000, Microsoft Query, SQL

Database: Teradata 15, Vertica, Oracle 11g/10g/9i, DB2 z/OS, Sybase, SQL Server

Scheduling Tools: WorkFlow Manager, ESP, Control-M,Tidal

Languages: SQL, PL/SQL, UNIX shell scripts,C++

Operating System: Windows NT/2000/XP, UNIX, Sun Solaris

Miscellaneous: JIRA,MQ Webspere, MS Visio, SharePoint, Altova XML

PROFESSIONAL EXPERIENCE

Confidential

ETL Manager(Sr. Lead)

Responsibilities:

• Gathered requirements for API usage reporting, Sevone and Optimus projects from the business users during Scrum meetings
• Designed and modelled the star schemas for loading API usage data into Teradata data warehouse and drafted SQL queries to generate reports for Optimus Java portal
• Drafted ETL design, architecture and use case documents for the concerned projects
• Developed complex Informatica mappings, workflows and Unix shell scripts to perform ETL for API usage data reporting
• Drafted complex BTEQ scripts to load billions of rows from flat file sources to Teradata and aggregated the data on an hourly, daily and monthly basis, for generating Sevone reports for the sales managers.
• Managed OPS team remotely and fixed multiple Teradata data warehouse production issues, on a regular basis.
• Interviewed prospective ETL resources for technical rounds, to build an in-house ETL team.
• Created POCs for the vendors, to fix and re-design the exception process handling process, in the existing Informatica ETL mappings.
• Created user stories and tasks in JIRA and updated status, for the tasks allocated in each Sprint.
• Tuned Informatica workflows for better performance, by re-designing the mappings and configuring proper session properties.
• Worked independently as an efficient team member, to deliver complex code components through good rapport with the DBAs, Business Analysts, Architects and fellow team members.

Environment: Teradata 16.0,UNIX,Informatica 10.2/ 9.6.1 Hotfix3,Microsoft Power BI, Business Objects, Oracle, SQL server, Postgre-SQL, Salesforce, JIRA

Confidential, New York, NY

Sr. ETL Lead Developer

Responsibilities:

• Reviewed the business requirement documents as part of Content factory and GUP projectsthrough multiple brainstorming sessions with BE and programming teams.
• Actively participated in building the ETL team and helping them with the onboarding process.
• Worked on end - to-end ETL design, drafted High-level and Detail-level design documents, and participated in code reviews.
• Designed the data models and UNIX components required for loading the flat files, xmls and data from various upstream systems including Cassandra db and created pocs in Kafka for GUP project.
• Worked with BI operational teams, to setup the SFTP bridges for receiving and sending Asset and Playlist files.
• Provided design and development estimates and worked closely with the project managers to come up with the project plan.
• Developed Informatica workflows, embedding complex logic using Java transformation to load data into Teradata and Vertica tables.
• Drafted the release notes and coordinated with the offshore teams for code deployment and
• Tidal teams for scheduling jobs in higher environments.
• Migrated huge volumes of data from various source platforms using Teradata utilities, as part of data integration.
• Created UNIX shell scripts for error alert generation, downloading files from SFTP, dynamic generation of parameter files from ETL configuration tables.
• Incorporated file validation, error handling, data cleansing and data validation rules into the mappings.
• Stretched beyond work hours to meet volatile requirements and deadlines.
• Embedded data reconciliation and audit processes, into all the ETL code components to make the ETL framework consistent across various subject areas.
• Worked closely with Projects managers, Business users, DBAs and QA team to accommodate the enhancements without slipping the deadlines.

Environment: Informatica Powercenter 9.6, Teradata 15, Vertica, Cognos, UNIX,Tidal Scheduler, SVN Tortoise, HP ALM,Big Data Platform

Confidential

Application D eveloper

Responsibilities:

• Actively participated in SHARE training sessions to understand the existingbusiness processes and the Java application.
• Performed data analysis for thorough understanding of data in ODS and all therelated SHARE schemas.
• Co-ordinated with the business users to consolidate the data reporting,data integration and data remediation requirements.
• Provided design solutions for various sources including flat files and relational tables.
• Created workflows to accommodate all the business logic necessary, to load huge volumes of data into the reporting layer, for hosting the reports in Business Objects.
• Actively participated in UAT of ETL code components for deployment to higher environments including QA,UAT and Production.
• Designed and Developed SQL scripts to fix SHARE UI issues, as part of data remediation efforts through multiple iterative cycles.
• Provided delta extracts of Product Family, Products, Applications and Evententities on a daily basis to RWS (Repository Work Space), as part of dataintegration process.
• Modified the existing VB and UNIX scripts for generation of the data extracts, archivaland automation of the PL/SQL scripts.
• Built a strong rapport with the DBAs,Business analysts, Project managers, Business users and fellow teammates to deliver reliable code components.

Environment: Informatica Powecenter, Oracle 11g,Windows Scheduler, Business Objects3.1,GEODIS,CVS,UNIX,XML