ETL Developer
Gurgaon
Technology
1 Openings
PRIMARY DUTIES/RESPONSIBILITIES:
* Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.
* Recommend and implement processes to improve data quality, data reliability, and database performance.
* Employ variety of ETL and integration tools for system and data integrations.
* Architect solutions that support data scientist and business stakeholders.
* Conduct ETL testing and data transformation testing.
* Develop data models for data science team that can be utilized for data mining.
* Maintain source to target documentation and process flow documentation.
* Take on DBMS responsibilities and wear multiple hats such as: ETL’s, serve as SQL Server DBA – Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.
* Proactively monitor ETL Processes / Jobs
EXPERIENCE:
• Relevant hands-on work experience in a Datawarehouse testing role. • ETL (Extract Transform Load)/ODS (Operational Data Store) experience. • MS SQL Server • Commercial Real Estate experience preferred. EDUCATION: • Bachelor’s degree in Computer Science or Information Technology from an accredited institution
SKILLS:
* ETL Tools: SSIS 5+ years, Azure Data Factory (ADF) 3+ year, ZappySys 1yr, APIs 2+ years. • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL), and working knowledge of Azure. • Proficient in MS SQL Server database including setting indexes, database security, and backups. • Data Testing: 6+ years • Fundamental knowledge of data warehouse concepts • Data Warehouse testing: 2+ year. • Javascript 1+ years, C# 2+ Years • Experience in data duality, source systems analysis, and business rules validation. • Ability to write and understand Source to Target documentation. • Detail oriented and meticulous approach to duties. • Keep our data separated and secure. Familiarity with data and cybersecurity. • Good analytical skills. • A knack for independent and group work. • Capacity to successfully manage a pipeline of duties with minimal supervision.
* Maintain and provide enhancements to data architecture within new/existing systems including Data Warehouse.
* Recommend and implement processes to improve data quality, data reliability, and database performance.
* Employ variety of ETL and integration tools for system and data integrations.
* Architect solutions that support data scientist and business stakeholders.
* Conduct ETL testing and data transformation testing.
* Develop data models for data science team that can be utilized for data mining.
* Maintain source to target documentation and process flow documentation.
* Take on DBMS responsibilities and wear multiple hats such as: ETL’s, serve as SQL Server DBA – Processes/Job/Error Handling/Troubleshooting/Scheduling, etc.
* Proactively monitor ETL Processes / Jobs
EXPERIENCE:
• Relevant hands-on work experience in a Datawarehouse testing role. • ETL (Extract Transform Load)/ODS (Operational Data Store) experience. • MS SQL Server • Commercial Real Estate experience preferred. EDUCATION: • Bachelor’s degree in Computer Science or Information Technology from an accredited institution
SKILLS:
* ETL Tools: SSIS 5+ years, Azure Data Factory (ADF) 3+ year, ZappySys 1yr, APIs 2+ years. • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL), and working knowledge of Azure. • Proficient in MS SQL Server database including setting indexes, database security, and backups. • Data Testing: 6+ years • Fundamental knowledge of data warehouse concepts • Data Warehouse testing: 2+ year. • Javascript 1+ years, C# 2+ Years • Experience in data duality, source systems analysis, and business rules validation. • Ability to write and understand Source to Target documentation. • Detail oriented and meticulous approach to duties. • Keep our data separated and secure. Familiarity with data and cybersecurity. • Good analytical skills. • A knack for independent and group work. • Capacity to successfully manage a pipeline of duties with minimal supervision.
Recruitment Notice
“Due to high interest, our team connects only with candidates whose profiles closely match the role mandate.”
Key Skills
ETL Tools: SSIS 5+ years, Azure Data Factory (ADF) 3+ year, ZappySys 1yr, APIs 2+ years. • Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases. (4+ years of SQL), and working knowledge of Azure. • Proficient in MS SQL Server database including setting indexes, database security, and backups.
Exploring your next leadership move?
Most leadership roles never reach job boards. ExecEdge helps senior professionals access the hidden leadership market through positioning, outreach, and warm introductions.