SUMMARY

• 7 years of Professional Experience in IT Industry.
• Worked as ETL And Database Developer and Reporting Resource in Confidential International Services
• Worked as System Integration Analyst in Confidential Client) as ETL Developer
• Worked as Sr. Software Engineer (ETL Developer) in Confidential.
• Worked as Sr. System Analyst in Confidential.
• Worked in Agile methodology with an overall experience in Development, implementation, testing, data analysis of Data Migration and ETL Application development projects.
• Well experienced in performing Error Handling and Troubleshooting. Worked alongside Data Architects and other functional teams to understand and analyze the requirements to develop ETL jobs.
• Handled various change requests that were raised because of production incidents and requirement changes.

TECHNICAL SKILLS

• SQL
• Database Developer
• ETL Developer
• ETL Data Specialist
• Oracle
• ETL/Database Developer used for data storage for all projects
• Unix, Linux
• Developer
• ETL Testing, Data Analysis
• DW/BI concepts
• Control - M
• GreenPlum
• JIRA, TFS
• GIT
• Business Objects
• Hadoop
• Tableau
• Developer
• MS Excel,MS Word, MS Outlook

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Responsibilities:

• Worked from the Scratch, End to End Development, Responsible for developing, implementing and documenting software changes and feature enhancements by analyzing requirement documents like mapping documents, project specification documents.
• Designing and implementing solutions with SQL Queries using Confidential as Target DB, and Source in Oracle understanding business requirements, functional and technical specifications.
• Ensuring all code written in SQL Override, Customized SQL Query in the mappings, and is tested and integrated with existing product code base and version control system in the mappings/macros.
• Designing new modules, enhancing, and maintaining existing code
• Developed optimized workflows/mappings /Control-m jobs to extract data from import files, transform as per business logic and load them to export files.
• Supported business changes in Agent site by fixing or changing the logic in database.
• Developed processes to generate monthly and daily Confidential reports.
• Developed new processes from scratch to support architectural changes.
• Analyzed data before loading into target database and investigated the defects and fixed the bugs.
• Analyzed and resolved many production issues by making the necessary code change or data fix.
• Tested and troubleshooted the data in Confidential environments.
• Supported production go-live and quickly fixed the issues if any.
• Performed batch monitoring, fixed the bugs and resolved the incidents raised as part of support activities.
• Created and maintained the database diagrams, flow chart and documentation related to the current project.
• Helped QA team and other team members by sharing knowledge on the processes I worked on.
• Perfectly communicated the root cause and solutions with team members and clients to resolve the issues on time.
• Transitioned the Projects to Support Teams L1/L2/ and L3 Teams

Environment: Informatica 9.1.0, Confidential - SQL, UNIX

Confidential

ETL Developer

Responsibilities:

• Analyzed requirement documents like mapping documents.
• Designed and developed informatica workflows as per the requirements.
• Developed Linux scripts required for triggering the ETL jobs as per schedule through CTRL-M.
• Developed SQL Macros to implement the required logic as per the requirements.
• Handled change requests due to change in business requirements.
• Involved in creating release documents like component check list, deployment documents etc
• Creating Control-M jobs for the developed workflows
• Creating test cases in TFS and thorough testing of the developed code (both UNIT & Integration Testing)
• Pushing the code to SIT environment (communicating the necessary instructions/dependencies) and getting the code tested.
• Handling CRs (Change Requests) efficiently
• Code & Instructions preparation for deployment
• Developed the code as per the ETL standards and had zero % BR rejections and EBR’s and redeployments.
• Tested the code of all projects properly to make sure getting the quality data in Business reports.

Environment: Informatica 9.1.0, Confidential - SQL, UNIX

Confidential

ETL Developer

Responsibilities:

• Done Profiling and Modelling Tasks in FOL team and played a role of DA/Tester for few sprints.
• Data Issues & gaps like Null issues in Confidential objects were identified through SQL Queries & resolved loading Actual data into Temporary Incremental table and updating on the base table.
• Data cleanup (including removing duplicates & addressing restatement of historical data) in most of the critical tables, SQL Query Tuning, Validating SQL Queries.
• Worked on Tuning the Bad Performing High Consuming SQL’s in Confidential and brought significant difference CPU usage.
• Good Knowledge on Process related Tasks like Raising Build Request, Preparing Test Cases in TFS, Run Book and in preparing the CRQ instructions, Raising Incidents for DML access
• Helped the Newly Joined Resources/Contractors and gave KT’s to understand the EBI Standards/Process.
• I have worked on Profiling and Data modelling for the new tables and created DDL’s played a role of Data Architect along with Development and Testing Activities and took ownership for deployments in chunks also involved in the Documents preparation for transitioning to Support Teams L1/L2 and L3.
• Made a set of Workflows that are not executing on Confidential (Engineering Team).
• To reduce the metadata of the Confidential list of Workflows and Control-M Jobs identified based on the Confidential executions which have not run since from past 2 Years.

Environment: Informatica 9.1.0, Confidential - SQL, UNIX

Confidential

ETL Developer

Responsibilities:

• Involved in all phases of SDLC from Requirement gathering, Providing Estimations, Requirement review, Detail design, Development, Code review, Unit Testing, User Training, Production support, Warranty support and Stress testing.
• Created informatica mappings, Sessions and workflows to transform data according to business requirements and load them into the data warehouse.
• Developed reusable mapplets and worklets.
• Migration of code across multiple environments
• Handled change requests, Customized SQL Queries, due to change in business requirements, Involved in Performance tuning of Informatica mappings.
• Prepared SQL Macros, Query Tuning in SQL and Unix scripts for validating the test data received from Confidential to prevent issues during the execution.
• Involved in END to END implementation from development to unit testing, SIT, UAT till production.
• Prepared technical design documents, unit test cases and uploaded them in SharePoint.
• Involved in understanding and fixing the user defects raised during User Acceptance testing

Environment: Informatica 9.1.0, Confidential, UNIX,SQL

Confidential

ETL Developer

Responsibilities:

• Worked on Confidential objects, loading data from Oracle to Confidential Implementing Confidential concept and Purging the historical load including Global Tie-outs for all the Objects.
• Was Part of Confidential end to end development in History as well as Incremental Load.
• It has a typical architecture with continuous change in requirements.
• Realized the importance of ETL Design with data model changes in Confidential with SQL Queries tuning.
• As part of testing, could resolve Data issues, SQL joins in the Queries, Special character Issues and other code related issues.
• Taken care of DDL Validations RC Validations, Data Validations, PK/PI Validations, Non-Functional Requirement Checks and Confidential Utilities.
• Managed to handle INFL process related tasks like Support Documents, run book meeting all the standards of L3, and Deployment activities.
• Also Worked End to End till the L1/L2 transitions, until we get L3 and Business signoff.
• Implemented the concept of Full Refresh and PDO as part of Development.
• Could explore and learn more options of Informatica as part of Unit testing.
• Supported Team Till the deployment and monitored the Control-M Jobs daily.

Environment: Informatica 9.1.0, Confidential, UNIX, SQL