| ETL Developer at Harrisburg, Pennsylvania, USA |
| Email: [email protected] |
| From: Farha khan, Tek Inspirations LLC [email protected] Reply to: [email protected] Job Description - Job Title: ETL Developer (SQL Azure/Synapse) Location: Harrisburg, PA(Hybrid) Duration: 6 Months NEED ONLY LOCAL CANDIDATES 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. WHAT YOU'LL NEED: 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. BONUS SKILLS: 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 Proficient in a variety of computer programming languages, such as SQL, PL/SQL, Unix shell Scripting, to successfully complete the tasks of the role. In depth knowledge of relational database systems. Keywords: procedural language Pennsylvania |
| [email protected] View all |
| Fri Jan 05 23:03:00 UTC 2024 |