| Job Opportunity :: Senior ETL Developer :: Hybrid at Laurel, MD :: Need Local Only at Laurel, New York, USA |
| Email: [email protected] |
|
http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1865593&uid= Greetings, I hope you're doing well. I'm Ankit Tiwari, a Technical Recruiter at FUSTIS LLC. We're currently looking to fill a vacant position as soon as possible. I kindly request you to review the following job requirements and advise if you are interested. Job Title: Senior ETL Developer Job Location: Hybrid in Laurel, MD 20707 locals only Experience: 12 Years of Experience Need. Visa: USC/GC/GC-EAD/H4-EAD/Only Need Local Please ======= Need 3 references for every sub (Name, Title, Organization, Phone/Email) Need the year completed for diplomas and certs Position: Senior ETL Developer Location: Laurel, MD 20707 Hours 8-5 pm 3 days in office, 2 days remote Work Auth: Duration: 2-year contract Anticipated Start Date : November 15, 2024 Work Hours : 8 to 5 plus one-hour lunch Work Schedule Hybrid Place of Performance: Laurel, MD 20707 Background check: Yes Vaccination required: No Interview Process/# of Rounds: 1 Job Title : Senior ETL Developer Scope of Work: The Senior ETL Developer with expertise in Informatica PowerCenter will design, develop, and administer ETL processes to support data integration and transformation for cloud-based data solutions. The role involves building and optimizing complex ETL workflows using Informatica PowerCenter to extract, transform, and load data from various sources into Azure Synapse Analytics and other data platforms. The candidate will manage the Informatica PowerCenter environment, ensuring high availability, security, and performance, while also leveraging Azure Synapse for data warehousing and analytics. They will collaborate with data engineers, business analysts, and stakeholders to understand data requirements, develop scalable ETL pipelines, and ensure data accuracy. Strong experience in both ETL L development and administration, cloud technologies like Azure, and SQL databases is essential. The role also involves maintaining documentation, performance tuning, and ensuring compliance with data governance standards. Job Description: 1. Design, develop, and optimize complex ETL workflows and mappings using Informatica PowerCenter to extract, transform, and load data from multiple sources. 2. Manage data integration from disparate systems (e.g., databases, flat files, APIs) into data warehouses, data lakes, and other repositories. 3. Administer the Informatica PowerCenter environment, including installation, configuration, upgrades, and patch management. 4. Monitor and optimize ETL processes for performance, including load balancing, parallel processing, and tuning transformations to minimize execution time. 5. Identify and resolve ETL issues, such as data inconsistencies, job failures, and performance bottlenecks, ensuring minimal downtime. 6. Ensure data accuracy, consistency, and completeness by implementing rigorous validation checks throughout the ETL process. 7. Work closely with business analysts, data architects, and stakeholders to gather data requirements and ensure the ETL solutions meet business objectives. 8. Create and maintain comprehensive documentation of ETL processes, workflows, mappings, and data models. 9. Automate ETL jobs and workflows, scheduling them for execution at optimal times, and managing dependencies across jobs. 10. Implement data cleansing, data quality checks, and transformation logic to ensure the integrity of data before loading. 11. Ensure that ETL processes comply with security standards and governance policies, managing access controls and data privacy. 12. Implement version control, manage updates to ETL processes, and ensure smooth transitions during changes to production environments. 13. Monitor and manage system resources, ensuring the ETL infrastructure can handle growing data volumes and future expansion. 14. Work with database administrators and engineers to optimize database performance and ensure data is structured efficiently for ETL processing. 15. Develop error-handling mechanisms, including logging, alerting, and rollback procedures to address issues in ETL workflows. 16. Provide guidance, mentorship, and support to junior ETL developers and other team members in best practices for ETL development. 17. Ensure ETL processes adhere to organizational data governance policies, including metadata management, data lineage, and audit trails. 18. Stay updated on the latest ETL tools, technologies, and best practices, and implement improvements in ETL processes to enhance efficiency and effectiveness. 19. Strong knowledge and experience with Oracle and SQL server databases 20. Expert in writing SQL and PL/SQL queries 21. Preferred to have experience in Python for creating data pipelines Preferred Experience/Qualification/Knowledge Skills Education: Bachelors Degree in Information Systems, Computer Science, or related scientific or technical field and three (3) years minimum of relevant experience General Experience: Work Experience: 3+ years of experience designing and implementing data solutions and creating data at enterprise-level applications. Industry Knowledge: Preferred to have experience in water and wastewater industry understanding of oracle utility applications. Project Experience: Demonstrated experience working on large-scale data projects in diverse team environments with a focus on analytics, business intelligence, and enterprise systems Specialized Experience Data Modeling: Extensive experience with data modeling and database design. Enterprise Analytics: Proven expertise in implementing enterprise-wide analytics and business intelligence solutions, including data integration from multiple systems into a single data repository. Skillset Database & Data Structures: Deep understanding of database design principles, SQL, PL/SQL, and Oracle database management systems, including performance optimization and troubleshooting. Data Governance & Quality: Familiarity with data governance frameworks, ensuring data integrity, quality, and security within an enterprise context. Communication & Collaboration: Excellent verbal and written communication skills, with the ability to work closely with stakeholders to translate business needs into technical solutions. Problem-Solving: Strong analytical skills and problem-solving abilities, especially when working with large, complex datasets Trust is Contagious!! Best Regards, Ankit Tiwari Technical Recruiter || FUSTIS LLC ankit.tiwari @fustis.com 3400 Cottage Way, Ste G2 #13814, Sacramento, California 95825 Keywords: green card procedural language Maryland Job Opportunity :: Senior ETL Developer :: Hybrid at Laurel, MD :: Need Local Only [email protected] http://bit.ly/4ey8w48 https://jobs.nvoids.com/job_details.jsp?id=1865593&uid= |
| [email protected] View All |
| 10:10 PM 22-Oct-24 |