Sr. ETL Developer

Job Details:

• Design, develop, test, implement, and maintain code for ETL, reports and other needs.
• Versioning and ETL changes as per the requirements, experience with a variety of transformations like Aggregate,
• Derived Column, Conditional Split and Data Conversion, Transaction, Checkpoints, SSIS Package Management,
• Debugging, Error handling and logging, SSIS Package deployment etc
• Design and develop ETL using SSIS/ADF from heterogeneous data sources.
• Create/Modify complex and large queries, writing/modifying stored procedures, functions, implementing error handling logic, performance tuning and query optimization, bug fixing, data auditing, SSIS package creation/modification and Production Job monitoring.
• Work closely with team members, DBAs, and business analysts to implement a sound solution, while adhering to agile methodology and lean integration techniques
• Automate and monitor jobs, rectifying issues within a timely manner ensuring SLAs are met
• Logical and physical database design following best practices and standards
• Work efficiently to resolve production support issues, escalating issues as needed.
• Maintain proficiency in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell scripting, in order to successfully complete the tasks of the role.
• Update and maintain Entity Relational Diagrams as required.

Key Skils:

• Minimum 5 years experience programming using PL/SQL.
• Experience using Oracle Transactional Database.
• Experience in Azure Synapse Link for SQL Server experience
• Bachelor's degree in Information Technology or related field from an accredited college or university.
• Minimum 2-3 years Data Warehousing/ETL experience, using SSIS.

Nice to have:

• Hands-on experience with gathering business requirements, documenting the reporting and analysis specifications, designing technical architecture, installing and configuring all components of an ETL tool, creating complex mappings, sessions, and workflows. Demonstrates sound understanding of development methodology.
• Demonstrates strong experience writing SQL, PL/SQL, and Unix Shell scripts.
• Experience on Microsoft Azure cloud services used like Storage services, Azure Databricks, Azure Data Lake, Azure Data Factory, Virtual Machines, App Service, Azure Active Directory, Azure Scheduler etc.
• Experience developing using Oracle APEX