• Migrates and maintains data pipelines to ingest and transform data from various sources.• Coaches a small team of data engineers in the design, development, and maintenance of ETL pipelines,resulting in lower counts of data related incidents in production.• Collaborates with data analysts and stakeholders to make sure that the transition from on-prem processes to Cloud is smooth.• Conducts bi-weekly end-to-end reviews off all code changes before the deployment in production.• Implements data quality checks to make sure that all data migrated to the new cloud platform are correct.• Works on workflow orchestration and making sure that all on-prem jobs that were already migrated are decommissioned properly with less impact to production.• Fixes high priority issues and data errors, resulting in shorter downtime and less escalations. • Troubleshoots AWS services such as (S3, EC2, Redshift, Lambda)• Taking a part on maintenance, outage, and upgrade planning.

• Documented all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.• Assisted on the development of technical best practices for data movement, data quality, data cleansing and other ETL-related activities.• Understands the range of options and best practices for common ETL design techniques such as change data capture, key generation and optimization• Provided technical knowledge of Extract/Transform/Load (ETL) solutions and translates it into working codes in Talend and Redshift.• Worked closely with project counterparts to ensure that the end to end designs meet the business and data requirements.• Ensured the ETL code delivered is running, conforms to specifications and design guidelines.• Unit testing ETL code to ensure it can be delivered and run in a system testing environment.• Helped with the analysis of issues raised during SIT and UAT.• Documented test procedures for systems and processes and coordinate with business analysts to resolve all requirement issues and maintain quality for the same.

• Designed, developed, implemented, and supported end-user systems.• Defined application system requirements that solved complex business problems and wrote new applications of moderate to significant complexity and scope.• Modified existing applications to comply with new business requirements.• Worked on process improvement such as data availability report automation.• Identified recurring issues and proposed and executed permanent fixes.• Provided BO related support to end users.• Proactively monitored all production jobs.• Provided technical support during outage and maintenance.• Worked as a key resource on various projects and small enhancements that required Informatica specialty.• Provided technical coaching to the team.

• Responsible for monitoring daily jobs using Control-M to meet the established SLA's.• Responsible for fixing Informatica workflow failures.• Provide thorough investigations on reoccurring job failures and creates proper documentations containing the fixes and possible future enhancements. • Contribute in the enhancements of the Informatica workflows for faster and error free execution.• Provide hand over status report that includes the current status of the system and to-do list.

• Responsible for the delivery of daily, weekly and monthly Business Intelligence reports used by the executive team within the established SLA's.• Responsible for the fixing of Informatica workflow failures during and after work hours.• Thoroughly reviewed Request for Change (RFC's) requesting deployment into the non-production environments prior to approval.• Validated associated code being deployed is checked in and deployment labels locked.• Assisted in the creation and maintenance of client specific documentation in support of a standard operating environment.• Supported new and existing SAS users providing them access rights to the production server.

• Developed ETL mappings using Informatica to implement the client’s requirements.• Communicated with the clients and 3rd party support team to discuss issues and requirements.• Involved in enhancements and maintenance activities of the data warehouse including tuning and modifying workflows for faster execution.• Effectively used Informatica parameter files for defining mapping and workflow variables.• Performed unit testing at various levels to ensure zero defect rate.• Fixed major bugs in the mapping and workflow levels.• Effectively worked in Informatica version based environment and used deployment groups to prepare the objects for migration.• Ran initialization scripts and verified migrated objects by executing full loads and scheduling incremental loads.• Communicated with the BO Team to discuss possible approaches that can lessen.• Updated old ETL Reports using SAP BO Web Intelligence (Webl) to reflect changes in the current ETL setup.• Created a data warehousing prototype for a new project related to report globalization.• Provided production support to the client.