Senior Integration Developer

Connection Irving , TX 75061

Posted 3 months ago

Connection Services has a fantastic opportunity for a Sr Integration Developer in the Irving, TX area.

The Sr. Integration Developer is responsible for supporting and providing data extraction, transformation and load needs through the development of new routines or the enhancement of existing routines. Collaborates with internal and external business and technology partners to understand business requirements and performs data analysis. Works with back-end data architects/systems engineers to construct data objects necessary for supporting these business requirements. Participates in data warehouse design, development, and monitoring to ensure that data is clean, accurate, available, and complete. Analyzes and creates complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts. Serves as subject matter expert within the team.

This is an exciting role in a challenging and fast-paced environment that requires business-customer partnership skills, business & technical acumen and the ability to effectively execute tasks on projects.

Essential Duties and Responsibilities:

  • Undertake a complete project through the entire SDLC of collecting requirements, recommending and designing a solution, creating project plans with realistic estimates, writing SSIS and Stored Procedures, Building Reports, Testing and Deploying relevant code

  • Responsible for moving data across multiple platforms using SSIS, familiar with high transaction driven applications, tuning complex SQL queries and building/maintaining SSRS reports and SSAS cubes

  • Conduct report design and development with Power BI

  • Develop ETL / ELT pipelines using source databases and REST services

  • Coordinate development of ETL/ELT/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics

  • Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts

  • Conduct ETL / ELT performance tuning, troubleshooting, support and capacity estimation

  • Develop, adhere to, and be a proponent for Data Warehouse development standards, including ETL / ELT standards and best practices

  • Maintain a thorough understanding of business and ETL / ELT processes; identifying efficiencies and needed controls to fine-tune ETL / ELT operations

  • Provide documentation for all developed ETL / ELT processes, including process flow and data mapping

  • Solve business problems using one or more Azure Data and Analytics services in combination with building data pipelines, data streams, and system integration

  • Maintain, design, and implement RESTful integrations with external and internal entities

  • Develop audit reporting and quality improvement processes to ensure accurate and consistent delivery of data

  • Work closely with different internal and external teams to troubleshoot issues and help them find a solution or design a suitable technical solution

  • Serve as subject matter expert within the team and apply specialized knowledge to support the organization's vision and direction

  • Knowledge of Azure Data Factory, Azure Databricks, Azure AD, Azure ADDS, etc is required

  • Perform other duties as assigned

Skills

  • Work with minimal supervision in an agile / DevOps environment, be an effective communicator with other technology team members and business stakeholders

  • Work with business leadership to understand problems and provide solutions

  • Excellent verbal and written communication skills & experience writing both technical and general documentation

  • Strong organizational skills for developing the proper policies and procedures to maintain and enforce quality data standards

  • The candidate must have strong analytical skills, he/she knows how to use technology to maintain a high level of data accuracy throughout the project lifecycle

  • Understand complex business and supply chain processes and how they tie with existing customizations, modules, and integrations

  • Ability to recommend improvements, plan future implementations, and build scalable customizations

  • Minimum Qualifications

  • Bachelor's degree /or equivalent combination of education and experience

  • 6+ years' experience with SQL Server 2012/2016/2017

  • 6+ years' experience SSIS

  • 2+ years' experience with SSRS, Power BI & Power shell scripting

  • 2+ years' experience working with Azure Databricks, Azure Dev Ops, Azure Data Factory and/or Azure Data Warehouse

  • Advanced SQL query techniques and automating import/export tasks using SSIS

  • Mastery of stored procedures, SQL coding, queries, index and database IO performance tuning.

  • Comprehensive understanding of Data Warehouse design principles.

  • Ability to proactively identify, troubleshoot and resolve complex data integrity issues.

  • Strong experience in ETL / ELT development and backroom processes required.

  • Strong SQL experience, including advanced query concepts and query performance tuning.

  • Ability to reverse engineer existing SQL code to determine business logic and create source-to-target mapping documents.

  • Experience using data warehouse with underlying SQL databases and/or analytical tools for business purposes

  • Experience connecting business requirements to data mining objectives and measuring business benefits

  • Knowledge of key data warehousing and database processes

  • Knowledge of RESTful communication

  • Desired Qualifications

  • Understanding of and experience in database administration

  • Experience in C# or Java or Python is preferred but not required.

  • Experience in Hadoop or other big data and NoSQL solutions is a plus.

  • Experience in cloud computing (PaaS and IaaS) environments.To learn more about Connection or to apply directly through our website, please visit https://recruiting.adp.com/srccar/public/RTI.home?d=External&c=1072441. Register to receive daily job updates!


  • Connection, Inc. and all of its subsidiary companies are committed to equal opportunity and proud to be affirmative action employers. All qualified applicants will receive consideration for employment, without regard to race, sex (including pregnancy), color, religion, age, national origin, ancestry, physical or mental disability status, medical condition, sexual orientation, marital status, protected veteran status, and all other characteristics protected by applicable state and federal law.

Send resumes to rocio.bonilla@connection.com for consideration.


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Senior Integration Developer

Accentvision Technology Inc

Posted 2 weeks ago

VIEW JOBS 2/1/2020 7:32:39 PM 2020-05-01T19:32 <p>• Undertake a complete project through the entire SDLC of collecting requirements, recommending and designing a solution, creating project plans with realistic estimates, writing SSIS and Stored Procedures, Building Reports, Testing and Deploying relevant code.<br /> • Responsible for moving data across multiple platforms using SSIS, familiar with high transaction driven applications, tuning complex SQL queries and building/maintaining SSRS reports and SSAS cubes.<br /> • Conduct report design and development with Power BI.<br /> • Develop ETL / ELT pipelines using source databases and REST services<br /> • Coordinate development of ETL/ELT/data warehouse best practices needed to support new and evolving sources of data used in reporting, transaction processing and analytics<br /> • Create and analyze complex SQL and SSIS as needed to support new and evolving data integration projects and data extracts<br /> • Conduct ETL / ELT performance tuning, troubleshooting, support and capacity<br /> estimation<br /> • Develop, adhere to, and be a proponent for Data Warehouse development standards,<br /> including ETL / ELT standards and best practices<br /> • Maintain a thorough understanding of business and ETL / ELT processes; identifying<br /> efficiencies and needed controls to fine-tune ETL / ELT operations<br /> • Provide documentation for all developed ETL / ELT processes, including process flow and<br /> data mapping<br /> • Solve business problems using one or more Azure Data and Analytics services in<br /> combination with building data pipelines, data streams, and system integration.<br /> • Maintain, design, and implement RESTful integrations with external and internal entities<br /> • Develop audit reporting and quality improvement processes to ensure accurate and<br /> consistent delivery of data<br /> • Work closely with different internal and external teams to troubleshoot issues and help<br /> them find a solution or design a suitable technical solution<br /> • Serve as subject matter expert within the team and apply specialized knowledge to<br /> support the organization's vision and direction<br /> • Knowledge of Azure Data Factory, Azure Databricks, Azure AD, Azure ADDS, etc is<br /> required.</p> <p><strong>Skills:</strong><br /> • Work with minimal supervision in an agile / DevOps environment, be an effective<br /> communicator with other technology team members and business stakeholders<br /> • Work with business leadership to understand problems and provide solutions<br /> • Excellent verbal and written communication skills & experience writing both technical<br /> and general documentation<br /> • Strong organizational skills for developing the proper policies and procedures to<br /> maintain and enforce quality data standards.<br /> • The candidate must have strong analytical skills, he/she knows how to use technology to<br /> maintain a high level of data accuracy throughout the project lifecycle<br /> • Understand complex business and supply chain processes and how they tie with existing<br /> customizations, modules, and integrations<br /> • Ability to recommend improvements, plan future implementations, and build scalable<br /> customizations</p> Accentvision Technology Inc Irving TX

Senior Integration Developer

Connection