SUMMARY

• Senior ETL developer with 10+years extensive experience inData warehousing, Data Analysis, ETL design, development, and maintenance.
• Integrated ETL with tools like Teradata, Oracle, MS SQL, Flat files, XML, EBCDIC files etc.Cloud enthusiast, self - learning Azure, Python3 and Tableau.
• Bachelor of Technology in Information Technology
• International Exposure: USA, Belgium
• Functional experience: Healthcare, Insurance, Communication, Capital Markets, Travel and Hospitality
• Working with clients to articulate and moderate business requirements.
• Analyzing requirements and defining solutions.
• Good understanding of Data Warehousing, Data Analysis, ETL, Data Modeling, Development, Maintenance, Testing and Documentation.
• Extensive experience in Repository Configuration and creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, processing tasks using Informatica Designer/Workflow Manager to move data from multiple source systems into targets.
• Well versed in Unix commands and programming using shell scripting and Python.
• Experience in performance tuning Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories.
• Experience in developing BTEQs, stored procedures, functions, views and triggers, complex queries and performance tuning SQL codes.
• Good knowledge of AWS, Python3. Performed POC using Python3 and AWS Lambda.
• Aspiring Technology - Microsoft Azure

TECHNICAL SKILLS

• ETL Tools
• Informatica 10.x/9.x/8.x
• Ab Initio
• SSIS
• Operating System
• Unix
• Windows
• Database
• Teradata
• Oracle
• MS SQL
• Snowflake
• Scheduling Tools
• Autosys
• CA Workload Automation
• Tidal
• File Types
• CSV
• XML
• JSON
• System Development Life cycle
• Agile (Scrum, Kanban)
• Waterfall Model
• Programming Language
• Shell Scripting
• Python
• PL/SQL
• Miscellaneous
• JIRA
• VersionOne
• Confluence
• Agile Ceremonies
• Microsoft Applications
• Data Warehousing
• Requirement Analysis
• Azure
• SQL, BTEQs

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Developer/Analyst

Responsibilities:

• Coordinate with business to gather requirements, developing solutions and providing timelines.
• Involved in development, maintenance and unit testing using PL/SQL, SSIS, Informatica, Oracle, MS SQL, Tidal.
• Performed code review to identifying gaps in development.
• Handling Dev, QA and PROD maintenance and ad-hoc issue.
• Involved with testers for code fix during SIT testing.
• Involved in Sprint ceremonies and creating JIRA stories for sprint.

Confidential

Senior ETL Developer/Analyst

Responsibilities:

• Working with business to gather and understand requirements.
• Developing solutions and providing timelines for requirements
• Worked on development, maintenance and unit testing of codes using Unix, shell scripting, Teradata, BTEQs, Oracle, CA Workload Automation, Informatica.
• Performing peer review of code and identifying gaps in development.
• Handling ad-hoc production issue
• Handled Informatica migration from 9.6 to 10.1.
• Worked on ftp to sftp POC and conversion project, total of 320 script were updated tested and migrated under strict timeline with no issues.
• Worked and lead SAS to ETL conversion project where existing SAS codes were analyzed and replicated to ETL code.
• Represented the team during Prod migration calls and weekly team updates.

Confidential

Senior ETL Developer/Analyst

Responsibilities:

• Conducting meetings with functional team to bridge the gap between user needs and code functionalities.
• Performed data analysis to keep requirement and data from sources in sync.
• Documented technical designs of codes developed for reference.
• Performed analysis/design/development/maintenance/unit testing of platform and product code using Informatica to ensured code integrity.
• Worked on platform codes to resolve defects and bring the code in sync with current requirements.
• Handled data from multiple sources like flat files (fixed width and delimited), ebcdic file, Oracle.
• Developed mappings to implement SCD2 logic and multiple insert/update/delete operation.
• Analyzed platform shell scripts and implemented reusable scripts to eliminate redundancy. Consolidated 46 scripts into 4 scripts maintaining the functionality, thus reducing maintenance.
• Conducted knowledge sharing sessions to provide insight of the working/functionality of codes developed.
• Conducted code reviews for peers to verify business requirement, code logic/standards are attained, and identify design flaws.
• Team representative for inter-team meetings, defect triages, weekly/daily team updates.

Confidential

Senior ETL Developer/Analyst

Responsibilities:

• Liaising with business users for gathering business requirements.
• Analyzing requirements, developing tactical plans and implementing ETL solutions.
• Providing project estimates for team efforts.
• Creating ETL code for business requirements as per the standard designs practices
• Integrated and transformed data from Oracle, flat-files, XML and mainframe sources.
• Implemented slowly changing dimensions Type 2 to load policies and hierarchical data into warehouse.
• Implemented Audit and Control points cycle checks, file validation, reject data capture, and financial balancing in phases of ETL codes.
• Conducted technical design walkthroughs and performed code review to meet quality standards.
• Performed dependency analysis between ETL jobs, shell scripts and implemented via Autosys.
• Identifying gap in designs, development and perform checks on activities in all phases.
• Debugging and fixing ad hoc ETL codes, shell scripts, dependency and SQL issues.
• Proactively developed utilities though UNIX shell script that compare xpaths, DDLs and DMLs and provide detailed report of discrepancies observed. This saved 40% of efforts of business team on reconciliation.
• Oversee major enhancements in existing shell scripts, ETL and SQL codes.
• Developed and implemented ETL code to update history impacted policies as per new business rules for capturing premium information in warehouse.
• Streamlining, developing implementation plan and coordinating deployment process.

Confidential

Senior ETL Developer

Responsibilities:

• Worked closely with clients to understand problem specifications and develop solutions.
• Created complex mappings using unconnected/connected Lookups, Aggregate, Router, Expression, Update strategy, Sequence generator transformations etc. for populating target table in efficient manner.
• Extracted data from different sources, Oracle and flat files using ETL tools and integrated with Informatica and Ab Initio to interact efficiently.
• Created mappings, mapplets, Sessions and Workflows to interact with Incentive Compensation Management system providing inbound data for efficient processing and outbound data for reports.
• Developed shell script to encrypt/decrypt, transfer, delete files in case of failures, and manage financial files to keep security of files on check.
• Worked on shell scripts to perform Informatica code reviews providing detail reports of workflows, sessions, mappings, mapplets, transformations etc. and keep check on coding standards.
• Involved in debugging Informatica ETL codes, shell scripts, SQL and fixing ad hoc issues.
• Streamlining, developing implementation plan and coordinating deployment process.
• Created mapplet to normalize record dynamically.
• Implemented restartability concepts using shell scripting to continue from failed workflow or script.
• Worked with clients to establish business solution under agile methodology.
• Integrated and transformed data from Oracle, flat-files and XML.
• Debugging and fixing ad hoc Informatica ETL code issues in higher environment.
• Maintained existing applications and designed and delivered new applications.
• Oversee enhancements in existing codes.
• Implemented restartability in on all batch process using link condition to restart from last failed session.
• Implemented reusable complex reconciliation code in Informatica using parametrization, transaction control, hashing etc. for Dodd frank act.