ETL Senior Developer

Job Role: ETL Senior Developer Location: Fargo, ND Duration: Long Term JOB SUMMARY

• The ETL Senior Developer is responsible for the design, development, and deployment of data extracts, transformations or loads, supporting the ingestion and transformation of data as needed for the client's data warehouse and any data file extracts that utilize Enterprise Data Analytics Solutions data assets.
• ETL development will utilize the Microsoft SQL platform, specifically SQL Server Integration Services (SSIS).

ESSENTIAL FUNCTIONS

• The ETL Senior Developer will be responsible for analyzing the business requirements for data file requests, designing, developing and deploying fully automated ETL jobs to produce data files
• Design, develop and deploy ETL programs to facilitate the receipt of data from various data sources, and the loading of data into destination tables within the overall data architecture framework.
• Experience with data lakes, data warehouses and other data management components utilized to establish data assets for reporting, analytics, and other data integration services.
• Experience with end-to-end solutioning for file creation and distribution, as well as supporting ETL production processes and operations
• Provider technical leadership within the Enterprise Data Solutions and Analytics teams, introducing new technologies, methods or processes to enhance data assets and capabilities
• Facilitates technical peer reviews and code reviews
• Mentors other programmers on best practices and technical advancements in the industry
• Works with various customers, prospects and stakeholders, understands and translates business use cases and/or requirements into data models, data flow diagrams and data integration routines.
• Advanced understanding of complex healthcare data models, identifying data sources and mapping data to required file specifications
• Designs and automates complex data quality and data validation/verification functions as part of the overall solution
• Leverages expertise in ETL and the MS SQL Platform to perform performance tuning
• Participates in proposing new technical architectures and solutions to improve and enhance existing architectures, processes and data services
• Facilitates collaborative data modeling activities or sessions among multiple stakeholders
• Expand the company's use of data as a strategic enabler of corporate goals and objectives

KNOWLEDGE, SKILLS AND ABILITIES REQUIRED IN ADVANCED LEVEL

• Analytical Thinking
• Attention to Detail and Accuracy
• Continuous Learning/Development (Self)
• Flexibility and Adaptability
• Leveraging Technology
• Prioritization and Organization of Work
• Research and Data Analysis
• Technical/Professional Knowledge and Skills

EXPERIENCE REQUIREMENTS

• Required: Minimum of 4 Years
• Preferred: Minimum of 5 Years

Experience Details:

• Experience with computer programming language(s) coding, building deployment software
• 4 Years experience using Microsoft's ASP.NET, SSIS, SSRS, C#, and the .NET Framework
• Experience with Axway (managed file transfer) and Opcon Scheduler a plus
• Solid knowledge of modern software design principles, concepts, and practices
• Outstanding analytical and quantitative skills
• Must have the ability to collaborate and communicate effectively in a dynamic work environment
• Advanced understanding of complex database methodologies, data analysis, SQL queries, ETL and business information management applications.
• 5 years experience designing, building and supporting ETL processes
• Expertise in database engineering skills on the MS SQL Server platform
• Experience with traditional as well as agile software development processes and methodologies
• Works well independently as well as with a diverse group of business users and technical experts to gather and clarify requirements as needed
• Excellent written and verbal communication skills.

ABOUT US

Apptad offers strategic consulting, enterprise information management and digital transformation services. With globally connected offices in US and India along with a team of trained and certified IT resources, Apptad ensures quick and effective delivery to its customers.Apptad is relentlessly reinventing the outlook of how companies leverage data.

With an effort to enable our customers the ability to solve biggest problems within their organization.We perceive our clients problems and respond with custom solutions instead of handing over boilerplate responses.

OUR MISSION

Customer Focus: We listen carefully to the needs of our clients so that we know what s important for their business and can design a customized solution for their business.

Innovation: As a firm, we believe in constantly upgrading ourselves and improving our solutions to adapt to the changing landscape of technology.

Accountability and Ethics: We believe in taking our commitments as seriously as our customers and living up to them while building trust for a long term business relationship.

- provided by Dice