Job Title: Senior ETL Developer
About the Company: DiLytics is a leading Information Technology (IT) Services provider completely focused on providing services in Analytics, Business Intelligence, Data Warehousing, Data Integration and Enterprise Performance Management areas. We have been growing for 14+ years and have offices in the US, Canada and India. We are an employee-friendly company that offers exciting and stress-free work culture and provides career paths where elements of job enrichment and flexibility to move across roles are inherent.
Responsibilities:
- Design and develop complex mappings, Process Flows and ETL scripts
- Perform data extraction and transformation using SQL query to create data set required for dashboard
- Should be able to document in detail. Ability to make right graph choices, use of data blending feature, Connect to several DB technologies
- Provide best practices and training support to other team members in BI technologies
- Design & develop BI reports and dashboards using Power Bi/Tableau and other tools to meet business analytic needs
- Help build and lead a great analytics team
Qualifications:
· Bachelor’s or master’s degree in a related field (e.g., Computer Science, Data Science, Information Technology).
· Candidate with 5+ years of ETL and DWH experience is preferrable - Mandatory
· Experience in applying the best practices in ETL & Data Warehouse - Mandatory
· Experience in installing/provisioning ETL tools - Mandatory
o Preferred: SSIS (SQL Server Integration Services) is a data integration
o ODI (Oracle Data Integrator) is an ETL and data integration tool from Oracle
o Informatica is a leading data integration and ETL (Extract, Transform, Load) tool
· Proven experience in designing and developing ETL pipelines/mappings with integration from SAP source systems (preferred).
· Expertise in the DI toolset and PL/SQL - Mandatory
· Hands-on with end-to-end Data Warehouse Implementation experience using DI (Data Integrator) - Mandatory
· Should have experience in designing / developing ETL processes such as ETL control tables, error logging, auditing, data quality, etc.
· Experience/Knowledge in SQL, PL/SQL. – Mandatory
· Experience in preparing Functional, Technical & Testing documents
· Experience in one or more of the following tools: OAC, Power BI, Tableau, OBIEE
· Must stay up to date on new and coming visualization technologies
· Excellent written, verbal communication and interpersonal skills
Pay: Up to ₹1,800,000.00 per year
Experience:
- SSIS: 5 years (Required)
- PL/SQL: 5 years (Preferred)
Work Location: Hybrid remote in Hyderabad, Telangana (Hyderabad, Hyderabad District)
