Abhishek Nigam

• Implemented data integration process involving Netezza, Oracle, and SQL Server.
• Developed MFP by implementing multiple data layers ranging from DL0 to DL4.
• Built DBT models to meet specific business requirements.
• Created efficient macros in DBT with Jinja scripting.
• Extensive experience using Snowflake Database for crafting diverse user-defined functions and procedures.
• Translated DataStage jobs from Teradata into Snowflake.
• Developed DataStage job for file migration from Snowflake to Amazon S3 Bucket.
• Developed multiple Snow scripts for data manipulation in Snowflake tables and views.
• Ensured timely delivery across all stages of the software development lifecycle.
• Employed GitHub and Jenkins for seamless migration of DataStage jobs through various test phases.
• Managed and tracked all ETL job processes with Control-M.
• Developed data engineering solutions and ETL processes supporting modeling operations.

• Provided expertise on IBM DataStage across organisation with focus on platform administration.
• Played a pivotal role as Technical Manager, leading various phases of the Data Warehouse lifecycle, including requirement gathering, design, development, testing, and production implementation.
• Led a successful upgrade and migration project, transitioning from DataStage 9.1 to 11.7.
• Acted as the Single Point of Contact (SPOC) for resolving technical issues in DataStage, Cognos, Oracle, and UNIX.
• Enhanced Clinical Study Drug Integration workflows with optimized ETL solutions.
• Collaborated with onsite and offshore teams for seamless project completion.
• Guided new resources in DataStage Administration and Development.

• Performed Datastage patch installations, project creation, user management, and environment configuration, ensuring seamless deployments and validated backups while automating alerts for operational efficiency.
• Managed ETL team tickets, driving resolution within SLA compliance, and implemented best practices to optimise ETL environments.
• Collaborated with clients on new projects, preparing high-level and low-level designs (HLD, LLD), ETL mapping templates, and test cases to support successful development and deployment.
• Led the migration from Datastage 8.7 to 11.5, ensuring minimal disruption and optimised performance.
• Scheduled and monitored weekly and monthly batch runs for smooth operation of ETL workflows.
• Addressed critical issues in collaboration with IBM, effectively managing the team and maintaining high system reliability.

• Analyzed and understood business requirements to design and develop ETL workflows tailored to project needs.
• Created and executed comprehensive unit test cases to ensure data integrity and process efficiency.
• Ensured smooth execution of system acceptance testing by providing thorough support.
• Successfully deployed ETL workflows to production environments, ensuring seamless operations.
• Implemented various automation initiatives to enhance efficiency and reduce manual intervention.

• Designed and developed reusable components to process multiple data feeds (Full, Delta, Incremental) for staging layers in the Data Warehouse.
• Resolved ETL-related issues in collaboration with clients.
• Parsed XML files using DataStage jobs to support data integration workflows.
• Created UNIX scripts to automate DataStage job execution via scheduling tools.
• Conducted migration, testing, and optimization of DataStage jobs in upgraded environments.
• Authored unit test cases to ensure data validation across various environments.

4o

• Monitored and administrated DataStage server performance and usage to ensure optimal operations.
• Created and managed projects, user roles, and permissions across environments.
• Implemented deployment processes in varied environments based on documented procedures release guidelines.
• Configured database connectivity and managed datasets across servers.
• Performed regular health checks, cleared locks, and resolved DataStage environmental issues.
• Debugged connectivity issues between DataStage servers and clients.
• Provided technical support and troubleshooting for DataStage versions 7.5, 8.1, and 9.1.
• Provided education and guidance to junior development staff.
• Established and enforced best practices for DataStage administration and usage.