3,823 Etl Architect jobs in the United States

. At least 8+ years of experience architecting and implementing complex ETL pipelines preferably with Spark toolset.2. At least 4+ years of experience with Java particularly within the data space3. Technical expertise regarding data models, database design development, data mining and segmentation techniques4. Good experience writing complex SQL and ETL processes5. Excellent coding and design skills, particularly in Java/Scala and Python and or Java.6. Experience working with large data volumes, including processing, transforming and transporting large-scale data7. Experience in AWS technologies such as EC2, Redshift, Cloud formation, EMR, AWS S3, AWS Analytics required.8. Big data related AWS technologies like HIVE, Presto, Hadoop required.9. AWS certification is preferable: AWS Developer/Architect/DevOps/Big Data10. Excellent working knowledge of Apache Hadoop, Apache Spark, Kafka, Scala, Python etc.11. Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy12. Good understanding & usage of algorithms and data structures13. Good Experience building reusable frameworks.14. Experience working in an Agile Team environment.15. AWS certification is preferable: AWS Developer/Architect/DevOps/Big Data16. Excellent communication skills both verbal and written"

We are looking for candidates who has extensive experience working with Teradata, SQL, physical and logical modeling.

The manager will hire the person over the phone. He would prefer local candidates, but if you have anyone non-local and they are good, please send them to me.

Req ID: 328379

NTT DATA strives to hire exceptional, innovative and passionate individuals who want to grow with us. If you want to be part of an inclusive, adaptable, and forward-thinking organization, apply now.

We are currently seeking a Informatica ETL Architect - REMOTE to join our team in Boston, Massachusetts (US-MA), United States (US).

Day to Day Responsibilities:

• Perform Data analysis, collect business requirements and identify business rules.

• Analyze, develop and support Data Integration, EDW and Data Management using Informatica, SQL, Oracle etc. platforms and tools.

• Collaborate with data modelling team to define data integration logic.

• Create data mappings necessary to fulfill the requirements.

• Build and test new ETL programs to fulfill the service requests.

• Automate the ETL processes and pipelines using scripting and Schedulers.

• Participate in Unit Testing, assist QA team in Integration Testing, and support Business team for UAT.

• Participate in code deployment and coordinate with different infrastructure teams during go-live, post-production, and continued support of end product.

• Debug data quality issues by analyzing the upstream sources and provide guidance to data integration team resolutions.

• Work closely work with DBAs to fix performance bottlenecks.

Minimum Requirements:

• 2+ years experience with clear responsibilities in an ETL / Extracts / Data Engineering Lead developer capacity.

• 10+ years experience in data integration (ETL) with 8 or more in solution development using Informatica suite.

• 8+ years experience in RDBMS / Data Warehousing platforms on Oracle

• Education: Bachelor's degree in Computer Engineering, Computer Science, Engineering, or related field of study

Preferred Skills:

• Must be an expert in Linux shell scripting to introduce automation as part of solution delivery.

• Strong SQL knowledge and ability to write most complex queries.

• Conceptual understanding of logical and physical data modelling is a must, and a working experience is a plus.

• Ability to develop and maintain data integration/ETL specifications that states integration rules and mappings.

• Ability to use documentation tools such as MS Visio and MS PowerPoint to diagram integration data flows.

• Ability to communicate effectively with business and technical staff members.

• Certifications in ETL and Data Warehouse platforms.

• Domain experience in Healthcare.

• Data profiling and implementation of automated solutions for data quality checks.

Where required by law, NTT DATA provides a reasonable range of compensation for specific roles. The starting pay range for this remote role is $105,840 - $45,000. This range reflects the minimum and maximum target compensation for the position across all US locations. Actual compensation will depend on a number of factors, including the candidate's actual work location, relevant experience, technical skills, and other qualifications.

INDHCLSMC

#LI-PAS

About NTT DATA

NTT DATA is a 30 billion trusted global innovator of business and technology services. We serve 75% of the Fortune Global 100 and are committed to helping clients innovate, optimize and transform for long term success. As a Global Top Employer, we have diverse experts in more than 50 countries and a robust partner ecosystem of established and start-up companies. Our services include business and technology consulting, data and artificial intelligence, industry solutions, as well as the development, implementation and management of applications, infrastructure and connectivity. We are one of the leading providers of digital and AI infrastructure in the world. NTT DATA is a part of NTT Group, which invests over 3.6 billion each year in R&D to help organizations and society move confidently and sustainably into the digital future. Visit us at us.nttdata.com (

NTT DATA endeavors to make accessible to any and all users. If you would like to contact us regarding the accessibility of our website or need assistance completing the application process, please contact us at . This contact information is for accommodation requests only and cannot be used to inquire about the status of applications. NTT DATA is an equal opportunity employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. For our EEO Policy Statement, please click here ( . If you'd like more information on your EEO rights under the law, please click here ( . For Pay Transparency information, please click here ( .

THE OVERALL PURPOSE OF POSITION:

• The purpose of this position is to provide support to the IT department.

SCOPE OF WORK

• Oversee and review work of team members, as needed or instructed.

• Partner with scrum masters/ project managers on optimizing scheduling, work allocations, and story assignments.

• Manage reporting environment including data sources, connections, security, subscriptions and metadata.

• Lead in initiative towards data access control and integrity across the enterprise.

• Create data models and schema for reliable and highly performant data marts and data warehouse.

• Develops complex ETL (extract, transform and load) SQL scripts to gather data from various databases and systems to make data available for enterprise analytics and reporting.

• Evaluate, test and implement new or upgraded software.

• Troubleshoot reported problems pertaining to reports and the reporting database environment, working closely with other IT members, especially DBAs, Systems Analysts and Systems Engineers, identifying the cause and designing or developing an approach for resolution.

• Assess impact of changes and updates to source production systems, planning and implementing resulting changes to reports.

• Identify areas for improvement within the EDS organization related to architecture, design, performance optimization, development process, workflows, governance, tools/technologies.

• Conduct end user training on data solutions.

QUALIFICATION AND EXPERIENCE:

• Bachelors degree and/or relevant technical training and certifications.

• Five (5) to Seven (7) years of directly related experience.

• Three (3) to Four (4) years of operational and/or technical business leadership experience.

• Five (5) years of experience with OLAP, industry standard databases, structured query language, ETL, reporting.

• Three (3) years of experience with data warehouse and data mart design, including Star and Snowflake models.

EDUCATION

• Bachelors degree with a strong academic record.

LENGTH OF EXPERIENCE

• The minimum amount of total work-related experience required is five (5+) years, for the position. This means experience in a related area or time spent performing similar work that provides the background for the current position.

• Want to get out of the typical ETL data integration career path?
• Would an Enterprise Data Integration career path add more excitement to your work?

• Informatica solution architecture (not a developer job!)
• Data integration best practices
• Integration process guidelines
• Data integration architecture changes
• US Citizen or Perm Resident/Green Card

• Data Architect, ETL Developer and Informatica Administrator will be responsible for advancing the role of data architecture at Client and across state agencies (Department of Personnel Administration - DPA) .
• Working with DPA and Client stakeholders, including other data architects and ETL developers and other subject matter experts, Data Architect will be responsible to advise, develop and facilitate data architecture strategy including cloud, advanced technologies & platforms for the DPA .
• In addition to the collaboration and development of the conceptual and logical models, logical solutions and physical data models, this particular role will also be responsible for development and support of ETL processes within Informatica platform, as well as for further Informatica configuration needed to support other Informatica capabilities needed for data catalog, data dictionary and data governance.
• It is expected that this initiative will last 9 months, with possibility of conversion to a full time Client employee.
• The contractor can work out of state; however, a Colorado resident is preferable. Working within the US is mandatory

Vistrada is seeking a highly motivated and experienced candidate to serve as an ETL Developer / Data Architect on our Business Intelligence ("BI") team supporting key clients.  Vistrada’s clients look to us to provide technical leadership and assist them in solving many of today’s most challenging digital transformation issues and complex data analytics needs.  In this role, you will help address operational challenges associated with data modeling, system architectures, data warehousing, integration, and other BI / analytics needs by applying advanced capabilities, modern technology, and best practices to real-world scenarios.  This candidate must have at least 4+ years of relevant experience, as described below:

Key Responsibilities:

Work closely with clients on a broad range of Data / BI-oriented areas, including:

• Analytics data warehouse architecture design, development, and testing.

• ETL environment implementation and migration.

• Report / Dashboard creation using leading visualization technology platforms (e.g., Tableau; Power BI; Qlik; OBIEE).

• Data modeling, involving both structured and unstructured data sets.

• Relational data architectures.

• Data integration processes.

• Model-based system engineering.

Required Qualifications:

• Bachelor of Science Degree, or equivalent 4-year degree, in computer science or related information technology field.

• 4+ years of related experience developing and maintaining data interchange systems, interfacing with a broad array of varying data sets, including flat files, direct database connection, and XML transactions.

• 4+ years of experience with ETL tools.

• 4+ years of experience with data modeling.

• 4+ years of experience developing data analytics ETL environments to support data analytics capabilities.

• 4+ years of experience with SQL.

• Experience with leading visualization technology platforms (e.g., Tableau; Power BI; Qlik; OBIEE).

• Ability to work independently and eager to learn new technologies, techniques, processes, software languages, platforms, and systems.

• Passionate, goal driven, team-oriented, and outgoing.

• Flexible, self-starter, and demonstrated ability to operate effectively with ambiguous and evolving objectives in a client-facing environment.

• Effective communication skills.

Preferred Qualifications:

• 3 years of experience using scripting languages (e.g., Python).

• 1 year of experience with Tableau Server Administration.

• 2 years of experience working with customers in data validation, troubleshooting, and business requirements definition activities.

• 7 years of experience performing database development using SQL or PL/SQL.

• 1 year of experience developing a data analytics ETL environment to specifically support Tableau visualizations.

• 1 year of experience using ETL techniques to support a data analytics program for a government entity.

• 2 satisfactorily completed statistics courses from an accredited college, or 1 year of professional experience using statistics.

• Strong written communication skills.

The anticipated annual salary range for this position is $80,000 - $130,000.

Company Background:

Vistrada is a business, technology and operations services organization dedicated to helping clients plan, design, implement and manage initiatives to generate revenue, manage costs, build and sustain operations, and analyze and optimize their business. 

Vistrada distinguishes itself by providing seasoned expertise with a flexible team structure allowing agility and responsiveness to our client’s evolving needs. This ensures we bring the right team at the right time while optimizing the client’s investment.   

Powered by JazzHR