Summary
Overview
Work History
Education
Skills
Work Preference
Timeline
Receptionist
Atishay Singhai

Atishay Singhai

Data Enginner
Hyderabad,Telangana

Summary

Data Engineer with over all 3+ years of experience in Healthcare domain implementing Software Development Life Cycle (SDLC) for Data Warehousing projects, includes Business requirements gathering, Analysis, Design, Development, Implementation and Maintenance of ETL (DataStage). In-depth experience in Extraction Transformation and Loading (ETL) processes using IBM WebSphere DataStage .

Overview

3
3
years of professional experience

Work History

Data Enginner

Innova Solutions
Hyderabad, Telangana
06.2021 - 07.2024
  • Self-motivated, with a strong sense of personal responsibility.
  • Worked effectively in fast-paced environments.
  • Skilled at working independently and collaboratively in a team environment.
  • Proven ability to learn quickly and adapt to new situations.
  • Excellent communication skills, both verbal and written.
  • Worked well in a team setting, providing support and guidance.
  • Assisted with day-to-day operations, working efficiently and productively with all team members.
  • Passionate about learning and committed to continual improvement.
  • Managed time efficiently in order to complete all tasks within deadlines.
  • Paid attention to detail while completing assignments.

ETL Developer(Datastage Developer)

Innova Solutions
Hyderabad, Telangana
2021.06 - 2024.07
  • For Centene Client with good Knowledge on Health Care Concepts
  • Extensively using DataStage designer to develop the jobs to extract data from heterogeneous sources
  • Developing parameter-driven ETL processes to map source systems to target data systems with DataStage developer
  • Designing and developing datastage jobs to read and write data into complex .dat files, comma delimited files, sequential files
  • Tuning DataStage jobs for better performance by creating DataStage lookup files for staging the data and lookups
  • Monitored jobs for performance issues and perform troubleshooting
  • Designing several DataStage jobs using join, merge, lookup, change apply, change capture, funnel, filter, ODBC, column generator, transformer, modify, surrogate key, aggregator, dcode, row generator and XML stages
  • Utilizing the environment variables and stage variables for developing parameter-driven jobs and debugging them
  • Developing complex transformations, surrogate keys, dimension tables, and fact tables
  • Extracting and transforming the source data from Oracle,Greenplum database and XML sources to load into the data warehouse in Oracle.
  • Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
  • Streamlined complex workflows by breaking them down into manageable components for easier implementation and maintenance.
  • Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
  • Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
  • Led end-to-end implementation of multiple high-impact projects from requirements gathering through deployment and post-launch support stages.
  • Established robust monitoring processes to detect system anomalies.
  • Automated routine tasks using Python scripts, increasing team productivity and reducing manual errors.

Software Developer Intern

Walkover Web Solution Pvt. Ltd Online
Indore, MADHYA PRADESH
02.2021 - 06.2021
  • Demonstrated adaptability by swiftly learning and applying new technologies, tools, and methodologies as needed throughout the internship period.
  • Developed strong problem-solving skills by troubleshooting complex issues during the internship period.
  • Worked with developers to identify and remove software bugs.
  • Collaborated with team members to design, develop, and launch a user-friendly software product.
  • Supported continuous integration efforts by writing automated tests for newly developed features.
  • Maintained strong knowledge of evolving technology trends.
  • Learned software engineering process improvements and best practices.
  • Improved communication skills while presenting progress updates at weekly team meetings and maintaining clear lines of communication with colleagues.
  • Used DevOps principles to automate software.
  • Optimized code performance by identifying bottlenecks and refactoring for improved efficiency.
  • Developed a thorough understanding of the software development life cycle through hands-on experience.
  • Documented technical workflows and knowledge to educate newly hired employees.
  • Contributed to improving overall software quality by participating in code reviews and providing constructive feedback.
  • Showcased excellent time management skills while juggling multiple tasks simultaneously under tight deadlines.
  • Developed reports using SQL server reporting services.
  • Designed and developed analytical data structures.

Education

M.Tech - Data Science and Engineering

BITS Pilani Work Integrated Learning Programme (WILP)
Current

Bachelor of Technology - Electronic and communication

Medi-caps University
08.2021

undefined

11.2023

undefined

12.2022

Skills

  • Technical Skills
  • ETL : IBM Information Server (Websphere Datastage And Quality stage Administrator)
  • Databases : Oracle, Greenplum, MS SQL Server, PL/SQL, TSQL Tools, SQLDBX, Dbeaver, RDBMS
  • Wharehouse : Snowflake, Snowpipe, Data Marts, Data Mining
  • Languages : Python,Java, Linux/UNIX Shell Scripting, Perl Scripting
  • Operating system : WINDOWS, UNIX, LINUX
  • Scheduler : Automic and Control-M
  • Other:
  • Data modelling, Data Warehouse, Data Pielining, ServiceNow, GitLab, Jenkinns, Data Management, Strong
  • Analytical skills,verbal communication skills
  • Production Work
  • Oracle Golden Gate
  • Data Extraction
  • Data Analysis

Work Preference

Work Type

Full Time

Location Preference

On-SiteRemoteHybrid

Important To Me

Work-life balanceCareer advancementPersonal development programsCompany CultureTeam Building / Company RetreatsHealthcare benefits

Timeline

ETL Developer(Datastage Developer)

Innova Solutions
2021.06 - 2024.07

Data Enginner

Innova Solutions
06.2021 - 07.2024

Software Developer Intern

Walkover Web Solution Pvt. Ltd Online
02.2021 - 06.2021

M.Tech - Data Science and Engineering

BITS Pilani Work Integrated Learning Programme (WILP)

Bachelor of Technology - Electronic and communication

Medi-caps University

undefined

undefined

Similar Profiles

CREATE PROFILE
Atishay SinghaiData Enginner