| etl Data Integration Developer at Remote, Remote, USA |
| Email: [email protected] |
| From: Laya, Incom Technologies [email protected] Reply to: [email protected] Role : ETL /Data Integration Developer (Intermediate/Expert) Work Type : Onsite(Candidates should be 100 miles from Lincoln,Nebrasaka) Client : Government of Nebrasaka(NeOCIO) Duration : 1 Year(Extendable) Max Payrate : 45$ Per Hour Relevant Experience : 5+ Years eSystems Inc. is a fast-growing Systems Integrator based in Princeton, New Jersey. We provide strategic IT solutions and services with primary practice areas in Java and Microsoft centric e-Business solutions, ERP solutions, Enterprise Application Integration, Data Warehousing and Business Intelligence solutions. Our clients include Fortune 500 corporations, government agencies, small and mid-sized local businesses, and non-profit organizations. As an equal opportunity employer, eSystems complies with all applicable laws, rules and regulations preventing discrimination against job applicants based on: race, ethnicity, religious beliefs, gender, gender identity, age, veteran status, marital status, physical challenges, or any other relevant factor THE JD and the required skillset are below. Please make sure that the suitable candidate has atleast 90% of the skillset mentioned. Summary: The ETL / Data integration Developer role will be responsible for developing and implementing ETL processes from a variety of data sources. This includes building high-level conceptual models, logical models and production of high-quality documentation. The ETL Developers will also participate in requirements gathering, collecting data definitions, source to target mapping, and defining and implementing data transformation, quality checking, cleansing, and standardization processes. The role will also be responsible for testing the resulting processes for accuracy and performance. Although this is an individual contributor role, this is a highly collaborative Agile team environment requiring personal flexibility in performing a variety of roles such as analyst, designer, developer, tester, troubleshoot, performance tunes and mentor when needed; all to take the necessary steps to ensure our customers' needs are met to the maximum extent possible in an accurate and timely manner. MINIMUM QUALIFICATIONS: Bachelor s degree in computer science or a related field or related experience. Minimum of five years of experience related to the essential functions of the position. Any equivalent education and\\or work experience may be substituted in order to meet the minimum qualifications of the position. PREFERRED QUALIFICATIONS: Extensive experience in data migration projects utilizing ETL/ELT tools, with strong expertise in database modeling techniques. Proven track record in application database re-engineering, redesign, and data migration from legacy databases across multiple agencies. Skilled in developing complex SQL Server PL/SQL, Stored Procedures, and ETL frameworks, with a strong grasp of data warehousing and cloud computing concepts. Proficient with a range of tools, including MuleSoft, Qlik, Talend, DataStage, AWS Glue, AWS Data Pipeline, and Azure Data Factory. Hands-on experience with database programming, Azure DevOps, Azure SQL, SQL performance tuning, data modeling, and ETL job scheduling. Successful execution of data warehousing projects across various platforms such as Snowflake, Databricks, Redshift, and other cloud-based data platforms. Knowledge and Abilities: KNOWLEDGE: Writes advanced SQL including some query tuning. Experience in the identification of data quality. Experience in creating ETL jobs using DataStage, Qlik, Talend or MuleSoft for data migration. Utilize ad-hoc techniques to perform on-the-fly analysis of data in all forms (structured, unstructured and semi structured). Proficient in how to design, implement, and troubleshoot a production Data Platform environment. Design, build and implement effective ETL/ELT jobs both in scheduled batch and real-time. Implement stored procedures and effectively query a database for multiple databases using established security procedures. Identify and test for bugs and bottlenecks in the ETL solution. Ensure the best possible performance and quality in the ETL packages. Provide support and fix issues in the ETL packages. Author and execute unit test scripts. Experience with the development and use of APIs for data sharing and consuming. Knowledgeable with data infrastructure both on premise and in the cloud. Preferable in Azure or AWS Experience working in a DevOps, Continuous Integration and Continuous Delivery environments. Work within developing and establishing policies, standards, procedures, practices of the State of Nebraska Department of OCIO. Keywords: active directory information technology procedural language etl Data Integration Developer [email protected] |
| [email protected] View all |
| Tue Oct 08 00:12:00 UTC 2024 |